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").