Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

can't attach adventurework database 2012 Expand / Collapse
Author
Message
Posted Tuesday, October 9, 2012 10:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 9, 2012 10:02 AM
Points: 1, Visits: 6
I am trying to attach aventurework database 2012, but I am getting an Operating system error 5: "5(Access is denied.)
Post #1370468
Posted Tuesday, October 9, 2012 11:07 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 11:06 AM
Points: 12,905, Visits: 32,179
access denied is usually because the account the SQL service is running from doesn't have access to teh specific folder the mdf exists in;
for example, if the mdf is on YOUR desktop , ie c:\Users\seyoumblen\Desktop ,
most other users do not have access to it ; all the folders specific to you have very limited permissions.

move the file to a more public folder, like c:\Data or something instead.


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1370494
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse