Tuesday, October 8, 2013
Error 5120 When Attached Database
I got error 5120 when attempted to attach sample database AdventureWorks2012 to Microsoft SQL Server 2012 ran on Microsoft Windows 8.1 Preview.
Solution to this problem is simple: Close the current Microsoft SQL Server Management Studio and run it as administrator to attach database. Also, do not use 'sa'. Use Windows Authentication instead.
Now, test it as normal user by update a record in the AdventureWorks2012 database.
Subscribe to:
Post Comments (Atom)
1 comment:
Use SQL data recovery tool to successfully attach SQL database & recover each & every database from corrupted MDF file. Read more: http://www.sqlrecoverysoftware.net/blog/how-to-fix-sql-error-5171.html
Post a Comment