Can't Attach Databases - Don't have permissions to access the file RRS feed

  • Question

  • Hi All:

    I've installed SQL Express 2005 on Vista.  I have no problems creating new databases, however, if I detach the database and then try to re-attach it I get an error telling me I don't have permissions to access the file.  In fact, it won't let me attach any database (*.mdf) file.

    Any ideas on what I need to do so I have permissions to attach databases?


    Thursday, April 23, 2009 1:26 PM

All replies

  • Hi Doug,

    try to run SSMS under Administrator Privileges. Right click on SSMS and choose Run as Administrator
    or turn off User Account Control.
    Thursday, April 23, 2009 2:14 PM