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

Error While Attach .mdf file in sql server 2005 Expand / Collapse
Author
Message
Posted Wednesday, May 6, 2009 10:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 28, 2010 10:01 PM
Points: 3, Visits: 15
I am facing the problem while attaching my sql server 2005 database.
the Error is" Create file encountrerd operating system error 5(access is denied" while attempting to open or create physical file

Plz do needfull.
Post #711291
Posted Wednesday, May 6, 2009 10:53 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 5:05 PM
Points: 20,738, Visits: 32,520
Looks like a permissions issue. You may not have the proper permissions to access the files where they reside.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #711303
Posted Wednesday, May 6, 2009 6:24 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 24, 2012 8:11 AM
Points: 1,097, Visits: 2,157
ashishnigam04r (5/6/2009)
I am facing the problem while attaching my sql server 2005 database.
the Error is" Create file encountrerd operating system error 5(access is denied" while attempting to open or create physical file

Plz do needfull.


Definitely its a permission issue. What permissions have you got on the server or on the file system?



Post #711700
Posted Thursday, May 7, 2009 6:15 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, November 13, 2012 5:04 AM
Points: 388, Visits: 93
I would check the permission on the folder where your data and tlog files are being put.
Post #711945
Posted Thursday, May 7, 2009 8:17 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 4:00 AM
Points: 4,427, Visits: 4,175
What's your OS?
If you use Windows2008 or Vista the UAC can cause this error while attaching a database.


Markus Bohse
Post #712055
Posted Thursday, May 7, 2009 8:52 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, June 1, 2009 6:06 AM
Points: 518, Visits: 354
The account that sql runs as needs to have the security privlege to access the directory or file.


+++BLADE+++
Post #712084
Posted Friday, May 8, 2009 12:27 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 10, 2012 11:34 AM
Points: 34, Visits: 128
its a permissions issue.
Post #713260
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse