title: Access is denied when attaching a database
body: <p>I am using SQL Server 2008 developer edition. I was trying to attach the AdventureWorks2008 database.  </p>
  
  <p>When I tried to attach, I received an "access is denied" error. According to the event log, it came from the O/S: </p>
  
  <blockquote>
    <p>Open failed: Could not open file D:\ProjectData\AdventureWorks\AdventureWorksLT2008_Data.mdf for file number 0.  OS error: 5(Access is denied.).</p>
  </blockquote>
  
  <p>I thought "NTFS problem", but System (and I) have modify access to both files.</p>
  
  <p>I found that I can successfully attach the database if I log in as sa, but my user account won't work.</p>
  
  <p>I am a member of the local administrators group on my machine, and I am in the sysadmins role in SQL Server instance.</p>
  
  <p>Any idea why I had to be logged in as sa?</p>