Plesk upgrade fails: PleskSQLServer: Access is denied. (Error code 5)

Symptoms

• Plesk upgrade fails with the following message:

  PLESK_ERROR: Upgrading Plesk SQL server... MSI: Error! Critical action 'Upgrade data of MySQL Server...' failed: Command "C:\Program Files (x86)\Parallels\Plesk\admin\bin\mysqlmng_adm.exe" --upgrade-server-data "--initial-ver=5.5" "--target-ver=5.5.54" failed with code 1. Output: Stop service... Removing InnoDB log files... Start service... Access is denied. (Error code 5) at StartService 'PleskSQLServer' at (service::startService line 211) at startService(PleskSQLServer)(service::startService line 274) at execute console command --upgrade-server-data(vconsoleapp::start line 122) at execute "C:\Program Files (x86)\Parallels\Plesk\admin\bin\mysqlmng_adm.exe" --upgrade-server-data "--initial-ver=5.5" "--target-ver=5.5.54"(vconsoleapp::run line 139)
  at (CmdAction::Commit line 393) at Execute action Upgrade data of MySQL Server...(executeList line 271) Failed to install 'C:\ParallelsInstaller\parallels\PANEL-WIN_17.5.3\dist-msi-Microsoft-2003-i386\mysql-admin.msi': Fatal error during installation. (Error code 1603) Error: The installation of the package 'mysql' failed with code 1603. (upgrade: Upgrading Plesk SQL server...)

• Executing of the command below shows the same error:

  C:\> msiexec /i "C:\ParallelsInstaller\parallels\PANEL-WIN_17.0.17\dist-msi-Microsoft-2003-i386\php70_mu017.msi" /L*V "C:\MyFile.log" AUTOINSTALLER=1

• Plesk SQL Server service cannot be started due to the following error:

  CONFIG_TEXT: Access is denied. (Error code 5)

Cause

Incorrect permissions on the %plesk_dir%MySQL folder or/and its files and subfolders.

Resolution

1. Connect to the server via RDP.

2. Open Plesk Reconfigurator.

3. Click the Repair Plesk installation button:

   

4. Mark Plesk File Security and Plesk Services checkboxes and click the Check button:

   

5. Start the Plesk SQL Server service via Plesk Services Monitor if it was not started automatically on the previous step:

   

6. Continue Plesk upgrade via Plesk > Tools & Settings > Updates and Upgrades.