I’m an using Admin account on Windows 7 and try to attach umbraco database to my local SQL 2008 R2 instance. I’m getting the following error:

Unable to open the physical file "D:\Tech\umbraco\build\App_Data\umbraco.mdf". Operating system error 5: "5(Access is denied.)". (Microsoft SQL Server, Error: 5120)

What the heck? I tried to brainstorm what the issue is and found out that I didn’t open my SSMS with “Run As Administrator” (although I’m using Admin account in Win7 and the same to use SSMS). Once I did that, I was able to attach the DB without any issue. What a bummer!

Hope this helps!

4 Comments

• Jewelers Row Chicago said Thursday, January 6, 2011 7:30:28 AM

  Nice post!! Thanks for sharing a wonderful information.

• Ryan said Tuesday, March 1, 2011 4:10:41 AM

  You're the best@!!!

• NM said Thursday, April 7, 2011 9:26:43 AM

  how to run it as administrator ?? =S
  

• Ahmed said Sunday, July 10, 2011 7:41:33 PM

  Thank u for your helpful information