Symptoms
-
Unable to change properties of MS SQL database server or create database in Plesk due to the following error:
PLESK_ERROR: Error: The test connection to the database server has failed because of network problems:
Get database server version failed: mssqlmng failed: [DBNETLIB][ConnectionOpen (ParseConnectParams()).]Invalid connection.
at (VADOConnection::open line 48)
at Unable to ADO conect with connection string: Provider=SQLOLEDB.1;Initial Catalog=master;Data Source=,localhost(VADODatabaseProvider::connect line 182)
at execute console command –get-server-version(vconsoleapp::start line 100)
at execute “C:Program Files (x86)ParallelsPleskadminbinmssqlmng.exe” –get-server-version “–server=,localhost” “–login=sa” “–password=*”(vconsoleapp::run line 117)
(Error code 1) -
Additionally, it is not possible to create a backup or migrate databases due to the same error.
OR
-
Unable to add or update an MS SQL database server in Plesk, it fails with one of the errors below:
PLESK_ERROR: Error: The test connection to the database server has failed because of network problems:
Try to establish connection failedOR
PLESK_ERROR: Get database server version failed: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (Error code 1)
-
It’s not possible to export, import or to manage an MS SQL database, the following message is shown:
The server is unavailable.
-
The following error might be shown in the
%plesk_dir%adminphp_error.log
file:
ERR [panel] "C:Program Files (x86)ParallelsPleskadminbinmssqlmng" --check "--server=.MSSQLSERVER2012" "--login=sa" "--password=******" failed with code 1.
stdout:
Login failed for user 'sa'.
at (VADOConnection::open line 48)
at Unable to ADO conect with connection string: Provider=SQLNCLI11;Initial Catalog=master;Data Source=.MSSQLSERVER2012(VADODatabaseProvider::connect line 182)
at execute console command --check(vconsoleapp::start line 93)
at execute "C:Program Files (x86)ParallelsPleskadminbinmssqlmng" --check "--server=.MSSQLSERVER2012" "--login=sa" "--password=*"(vconsoleapp::run line 110)
stderr: -
The following message can be found in Start > Event Viewer > Applications and Services Logs > Plesk:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. at (VADOConnection::open line 62) at Unable to ADO conect with connection string: Provider=SQLOLEDB.1;Initial Catalog=master;Data Source=203.0.113.2SQL2008(VADODatabaseProvider::connect line 181) at execute console command --check(vconsoleapp::start line 132) at execute "C:Program Files (x86)ParallelsPlesk/admin/bin/mssqlmng" --check "--server=203.0.113.2SQL2008" "--login=sa" "--password=*"(vconsoleapp::run line 143) Execute file name: C:Program Files (x86)ParallelsPleskadminbinmssqlmng.exe
Cause
There are several possible causes:
-
Connection issue.
-
Incorrect login/password credentials.
-
The disabled login.
Resolution
-
Connect to the server via RDP.
-
Go to Start > Services and make sure that the SQL Server (MSSQLSERVERXXXX) and SQL Server browser services are running on the server and start them if they are stopped.
Note: The SQL Server (MSSQLSERVERXXXX) can take one of the following values depending on which MSSQL server the issue occurs:
SQL Server (MSSQLSERVER)
SQL Server (MSSQLSERVER2012)
SQL Server (MSSQLSERVER2014)
SQL Server (MSSQLSERVER2016) -
Ensure that the SQL Server and Windows Authentication mode and login for the user (usually it is the “sa” user) are enabled.
-
Make sure that you can…