I am trying to attach AdventureWorks2008R2_Data on my MS SQL 2008R2 Server, but it gaves me an error :
_____TITLE: Microsoft SQL Server Management Studio
Attach database failed for Server 'SERVERNAME'. (Microsoft.SqlServer.Smo)
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Unable to open the physical file "E:\username\MS SQL SERVER 2008 R2\AdventureWorks2008R2_Data.mdf". Operating system error 5: "5(Access is denied.)". (Microsoft SQL Server, Error: 5120)
Anyone can please email me a text file containing SQL Script for this particular AdventureWorks DB?
waiting... (as many others, same issue with many people here)