Unable to create a domain backup with MS SQL database: Operating system error 5(Access is denied)

Created:

2016-11-16 13:23:05 UTC

Modified:

2017-08-08 13:26:16 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to create a domain backup with MS SQL database: Operating system error 5(Access is denied)

Applicable to:

  • Plesk Onyx for Windows
  • Plesk 12.5 for Windows
  • Plesk 12.0 for Windows

Symptoms

Unable to create a domain backup with MS SQL database.

The following error can be found in the file %plesk_dir%admin\logs\php_error.log:

[2015-04-18 12:12:18] ERR [panel] Unable to backup database 'db_'
Cannot open backup device 'C:\\Program Files (x86)\\Parallels\\Plesk\\Backup\\example.com\\databases\\example-182\\123'. Operating system error 5(Access is denied.).
BACKUP DATABASE is terminating abnormally.

(Error code 21):
0: Database.php:487
Db_Table_Row_Database->_executeDbBackupCommand(array, array)
1: Database.php:314
Db_Table_Row_Database->backup(string 'C:\\Program Files (x86)\\Parallels\\Plesk\\Backup\\example.com\\databases\\example-182\\123')
2: class.DbBackupManager.php:224
DbBackupManager->Backup(string '123')
3: client.domain.dbbackup.create.php:82
plesk__client__domain__dbbackup__create->accessItem(string 'POST', NULL null)
4: UIPointer.php:619
UIPointer->access(string 'POST')
5: plesk.php:36

Cause

Insufficient permissions on the folder %plesk_dir%Backup for the SQL service user.

Resolution

Add full permissions on the folder %plesk_dir%Backup for MSSQL user using the following way:

  1. Edit %plesk_dir%etc\DiskSecurity\MssqlSecurity.xml adding this string to file:

    <Entries><Entry AccounType="1" Domain="NT Service" Account="MSSQL$MSSQLSERVER2012" Path="[PRODUCT_ROOT_D]" SubPath="Backup" AceFlags="ThisFolderSubfoldersAndFiles" AccessMask="FullAccess" EntryFlags="0"/><Entry AccounType="1" Domain="NT Service" Account="MSSQL$SQLEXPRESS" Path="[PRODUCT_ROOT_D]" SubPath="Backup" AceFlags="ThisFolderSubfoldersAndFiles" AccessMask="FullAccess" EntryFlags="0"/></Entries>

    where MSSQL$SQLEXPRESS is a user for SQL Sever service.

  2. Run Plesk Reconfigurator > Repair Plesk installation > Plesk File Security.

The following articles can be useful:

Have more questions? Submit a request
Please sign in to leave a comment.