Access Denied When Attaching SQL Server Database

SQL Server - Access Denied

SQL Server – Access Denied

When you try to attach a SQl Server database (MDF file), you might face this “Access is denied” error. One of the example is the AdventureWorks sample database.

To bypass this error, all you need to do is to launch the SQL Server Management Studio in Administrator mode. The steps:-

SQL Server - Administrator Mode

SQL Server – Administrator Mode

  1. Locate the SQL Server Management Studio shortcut.
  2. Right click on the shortcut and select “Run as administrator”.
  3. You should be able to attach the database now!

About HMMaster

I'm just an IT guy working in the IT world. I love to explore new things and the web is the best way to explore!
This entry was posted in Guide, Software and tagged , , , , , . Bookmark the permalink.

One Response to Access Denied When Attaching SQL Server Database

  1. porcodio says:

    No. It’s not attachable

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.