Can't attach northwind database to sql server 2008 R2
northwind, sql-server
Solution
Error 5120 is a sharing violation on the file you're opening. Try starting SQL Management Studio as Administrator and make sure that the db isn't attached already.
Problem
When I try to I get the following error in SQL Server Management Studio: TITLE: Microsoft SQL Server Management Studio Attach database failed for Server 'AHAKEEM'. (Microsoft.SqlServer.Smo) ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) Unable to open the physical file "C:\SQL Server 2000 Sample Databases\northwnd.mdf". Operating system error 5: "5(failed to retrieve text for this error. Reason: 15105)". (Microsoft SQL Server, Error: 5120) This is a fresh version of `Northwinds mdf` which just came from Microsoft's installer.