3
Vote

AdventureWorksLT2012 data file attachment issue

description

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

file attachments

comments

shreyas14 wrote Apr 8 at 11:21 AM

How to solve this issue?

jerriclynsjohn wrote Apr 18 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 at 12:15 AM

or try removing the log file and attach again