Thursday, September 11, 2008

SQL 2008 Error 5120

Today I was trying to attach some databases to SQL 2008 on a Vista machine but kept getting Error 5120. To avoid this problem you must start SQL Server Management Studio in Administrator mode. (right click the link, select Properties, click Advanced and enable "run as Administrator").

2 comments:

yasser m f said...

thank you
this information was very very useful for me .

I've setup SQL Many times because of this error.

Ellis White said...

Know how to resolve SQL error 5120 & recover corrupt SQL database with a third party tool i.e. SQL recovery tool. http://www.sqlrecoverysoftware.net/blog/how-to-fix-sql-error-5171.html