Getting Error While Attaching the Database in SQL Server

Question

I have a MDF file and no associated LDF file for a database created in MS SQL Server 2008. When I am trying to attach the MDF file to a different SQL Server, then I am facing error.

Unable to open the physical file "D:\Database2. mdf". Operating system error 5: "5(Access is denied.)". (Microsoft SQL Server, Error: 5120)

Edwin J. Hoffer · Accepted Answer

You need to provide the modify privilege to the SQL Service accounts to the folder  C:\ArrowSQL\Arr@Data and then attach the db, it will attach without privilege error! nNow, if you are using windows 7. Open the SSMS like this - Right click -> Run as Administrator and then login in windows mode and try to attach the database files.

Mariya Beckham · Answer

When I followed the instructions given by you, the same error prompted that's why I am unable to attach the. mdf file. What may the possible reasons for this error?

David Ross · Answer

Please make sure that. mdf file and. ldf file on the same drive

Kerry Wilson · Answer

n Go to the folder where mdf file is stored.  n Select file  n Right click on the file n Give full permissions to file for logged in user Security.  n nnn

Edwin J. Hoffer · Answer

What may the possible reasons for this error?

nnThe problem of operating system error 5(access is denied.) is due to lack of permissions for SQL Server to access the Primary (. mdf) & Log (. ldf) files. nnAnd to fix this error nChange the MSSQLSERVER service startup user account, with the user account who have better privileges on the files and then try to attach the database. nOr nStartup with windows administrator account, and open SQL Server with run as administrator option and try to login with windows authentication and now try to attach the database.

Mariya Beckham · Answer

Thanks Andrew and Michael for your clarifications, I have fixed my problem