Thursday, December 1, 2011

AdventureWorks and SQL Server 2012 RC0 and Access Denied

While attaching AdventureWorksDWDenali_Data.mdf to SQL Server 2012 RC0 if you get this error:
Unable to open the physical file "C:\Data\AdventureWorksDWDenali_Data.mdf". Operating system error 5: "5(Access is denied.)".

To fix Right Click --> Properties --> Security

Give Full Control access to the account you would be using.

Attach to database again.

1 comment:

  1. Your blog was excellent. I am waiting for more to see in your blog...really its very informative for us. Thanks for sharing..
    Visit Website