Return
-
Title
MSSQL '5(Access is denied.)' error during restoring database -
Description
The following error message has been observed while restoring the MSSQL database to an alternate location:
The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'E:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\XXXXXX.mdf'
-
Cause
The account the SQL server is running under does not have access to the location to restore the database -
Resolution
We can use SQL Server Configuration Manager to find which account is used to run the SQL Server instance, and then make sure that account has full control
Steps to Resolve-
- Open
Sql Server Configuration manager - Right
click on SQL Server (MSSQLSERVER) - Go to
Properties - Change
log On Asvalue toLocalSystem
Re-run the restore job.
- Open
-
Attachments
-
Additional Information
Restore of MSSQL to alternate Location
