Getting Error while Attaching the Database in SQL Server
- This topic has 6 replies, 4 voices, and was last updated 8 years ago by .
-
Posts
-
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!!
Now, 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.Please make sure that .mdf file and .ldf file on the same drive
- Go to the folder where mdf file is stored.
- Select file
- Right click on the file
- Give full permissions to file for logged in user Security.
What may the possible reasons for this error?
The 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.
And to fix this error
Change the MSSQLSERVER service startup user account, with the user account who have better privileges on the files and then try to attach the database.
Or
Startup 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.
- You must be logged in to reply to this topic.