JimNolandCBI


When attempting to restore a database, I get the following error:

'Cannot open backup device, (filename).bak, Operating system error 5, access is denied.'

I get similar errors when attempting to attach the database file, it shows up in the Mngt. Tool as 'read only'.

This error does not occur when restoring the same .bak file to other pc's. On the problem pc, we have completely uninstalled and reinstalled Sql Express and Mngt. Tool Express. It occurs whether logged in as full administrator or other user.




Re: Error restoring database

Deepak Rangarajan


check the path where the backup file resides whether you could access it....may be that mite cause the above error






Re: Error restoring database

Jens K. Suessmeyer

Which OS are you running on using Vista it might be caused that you don¨t have elevated rights (although logged on with an administrator account)

Jens K. Suessmeyer

---
http://www.sqlserver2005.de
---






Re: Error restoring database

JimNolandCBI

OS is xp-pro.

The directory of the file is accessible as well.





Re: Error restoring database

Jens K. Suessmeyer

Are you connecting using SQL Server authentication Then you will be impersonated with the SQL Server account which is running the service on the machine. If this one does not have permissions on the file / directory, then you probably will get the Permission denied error message.

Jens K. Suessmeyer

---
http://www.sqlserver2005.de
---





Re: Error restoring database

JimNolandCBI

Have tried using SQL authentication and windows authentication. How do you determine if the sql server account has particular permissions on the file/directory





Re: Error restoring database

Deepak Rangarajan

just right click the file/directory and go to security tab and check the permission for the sql service account