Admin-Ahead Community
Windows => Control Panels => WebsitePanel => Topic started by: Chetan Singh on February 01, 2014, 10:45:37 am
-
Hello,
If you are getting following error while restoring database backup from the WebsitePanel, please follow these steps to fix this.
ERROR:
======================>>>
[1/7/2014 5:34:05 PM] ERROR: 'Microsoft SQL Server 2012' RestoreDatabase
System.Data.SqlClient.SqlException (0x80131904): Cannot open backup device 'C:\Users\WPServer\AppData\Local\Temp\e11c4047-91f6-4fda-8ef2-73ffbd00db72\SWDdb.bak'. Operating system error 5(Access is denied.).
RESTORE FILELIST is terminating abnormally.
======================>>>
Actually the problem comes from the MS SQL permissions. In order for the SQL to write or read in the temp folder… C:\Users\WPServer\AppData\Local\Temp\ it has to have permission. You need to see from what user does your MS SQL server runs on the server (it should be something like NT Service\MSSQL$SQLEXPRESS) give that user the permissions to the folder (only read and write). One thing to note is: don’t try to find the user I mentioned with Find in the Properties > Security.
Thank you,