Knowledge Base

Can’t start PleskSQLServer service: System error 1058 has occurred. The service cannot be started

Symptoms

Plesk upgrade failed with an error

Info 1923.Service 'Plesk SQL Server' (PleskSQLServer) could not be installed. Verify that you have sufficient privileges to install system services MSI (04): ExecServiceConfig: Error 0x80070430: Cannot change service configuration. Error: The specified service has been marked for deletion. Failed to install 'C:ParallelsInstallerparallelsPANEL-WIN_17.8.11dist-windowsmysql-admin_mu067.msi': Fatal error Action '' failed with error 1603(0x00000643) Error: The installation of the package 'mysql' failed with code 1603. (upgrade: Upgrading Plesk SQL server...)
The Plesk SQL service fails to start

System error 1058 has occurred. The service cannot be started, either because it is disabled or because it has no enabled devices associated with it.
There are no specific errors in the PleskSQL error log

Cause

The Plesk SQL service configuration has been corrupted during the update.

Resolution

Remove the corrupted service and recreate it.

Connect to the server over RDP
Open a Command Prompt as Administrator
Stop PleskSQLServer

net stop PleskSQLServer
Delete the service

sc delete PleskSQLServer
Recreate PleskSQLServer

sc create PleskSQLServer start= auto DisplayName= "Plesk SQL Server" binPath= ""%plesk_dir%MySQLbinmysqld.exe" --defaults-file="%plesk_dir%MySQLmy.ini" PleskSQLServer"
Configure the Log on user in the PleskSQLServer service

sc config "PleskSQLServer" obj= "NT ServicePleskSQLServer"
Start the service

net start PleskSQLServer
Continue with the Plesk upgrade using the following command and selecting the forward options

plesk installer --console --debug

Note: The following warning may appear during the upgrade; it can be safely ignored:

Continuing with the upgrade without having an appropriate product license key will result in the installation of a default license key with limited functionality. Administrators are advised to first acquire the appropriate license key before continuing with the product upgrade.