Get your server issues fixed by our experts for a price starting at just 25 USD/Hour. Click here to register and open a ticket with us now!

Author Topic: Unable to restore database from the WebsitePanel.  (Read 6301 times)

0 Members and 1 Guest are viewing this topic.

Chetan Singh

  • Full Member
  • ***
  • Posts: 123
  • Karma: +2/-0
  • Bienvenido a las Tecnologías de la Admin-Ahead.
    • Admin-Ahead Server Technologies.
Unable to restore database from the WebsitePanel.
« 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,

Get your server issues fixed by our experts for a price starting at just 25 USD/Hour. Click here to register and open a ticket with us now!