System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is denied.)'

Question

Hi all i'm having problem when trying to restore database backup i'm using SQL SERVER 2005 enterprise edition on win2k3 Enterprise edition

i'm using mixed mode for auth 

i get the following error any ideas thanks in adavance for your help

TITLE: Microsoft SQL Server Management Studio
------------------------------

Restore failed for Server 'MIS-896EDCB80BF'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'D:\Empty_umis\umis_demo'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

 

Answer 1

 

By the error message it seems that  the account used to restore the database doesn't have privileges to write the files on specified path 'D:\Empty_umis\umis_demo'

Answer 2

Hi Mangel, I am using my admin account to restore the database from the backup file. But i am unable to do so. Previously on the same server i had restored dbases from backups. Not sure whats going wrong.
When it coems to permissions...what do we need to check? PLEASE advice.

Answer 3

It is the service account for the database engine which is relevant. And note the folder in that error message. This is probably where it want to place any of the database files (can be specfied using the MOVE option of the restore command).

---

Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi