Can't attach northwind database to sql server 2008 R2

Question

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.

Answer 1

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.