AdventureWorksLT2012 data file attachment issue


having issues attaching AdventureWorksLt2012 mdf file to SQl 2012 express mgmt studio. Generating an error log stating 'access denied' .

file attachments


shreyas14 wrote Apr 8, 2014 at 11:21 AM

How to solve this issue?

jerriclynsjohn wrote Apr 18, 2014 at 4:55 AM

  1. Go to the location where .mdf is located
  2. Right Click on the .mdf file and select the tab "Security"
  3. Select the "User" that was logged in the SQL Server
  4. Click "Edit"
  5. Check the "full control" and save
Now attach the DB again, and it should work just fine.

Esther106 wrote Apr 26, 2014 at 12:15 AM

or try removing the log file and attach again