May 6, 2009 at 10:44 am
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.
May 6, 2009 at 10:53 am
Looks like a permissions issue. You may not have the proper permissions to access the files where they reside.
May 6, 2009 at 6:24 pm
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?
May 7, 2009 at 6:15 am
I would check the permission on the folder where your data and tlog files are being put.
May 7, 2009 at 8:17 am
What's your OS?
If you use Windows2008 or Vista the UAC can cause this error while attaching a database.
[font="Verdana"]Markus Bohse[/font]
May 7, 2009 at 8:52 am
The account that sql runs as needs to have the security privlege to access the directory or file.
[font="Comic Sans MS"]+++BLADE+++[/font]:cool:
May 8, 2009 at 12:27 pm
its a permissions issue.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply