[Troubleshooting] Unable to add/update/export MS SQL database server or create database on Plesk: Test connection to the database server has failed because of network problems

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 failed

  OR

  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:

1. Connection issue.

2. Incorrect login/password credentials.

3. The disabled login.

Resolution

1. Connect to the server via RDP.

2. 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)

   

3. Ensure that the SQL Server and Windows Authentication mode and login for the user (usually it is the “sa” user) are enabled.

4. Make sure that you can…