Error While Attach .mdf file in sql server 2005

  • 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.

  • Looks like a permissions issue. You may not have the proper permissions to access the files where they reside.

  • 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?

  • I would check the permission on the folder where your data and tlog files are being put.

  • 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]

  • 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:

  • 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