MSSQL version and port are missing in Tools&Settings

Symptoms

After installation of MSSQL Server through Plesk installer, the server and port number are not displayed in  Home > Tools & Settings > Database Servers

The query shows that database server version and port are missing in Plesk database:

CONFIG_TEXT: mysql> select * from databaseservers;
id: 2
host: .\MSSQLSERVER2012
port:
type: mssql
server_version: 0
admin_login: sa
admin_password: $AES-128-*********************************
parameters_id: NULL
last_error: no_error

Cause

Bug #PPPM-7226 . Will be fixed in further versions.

Resolution

1. Connect to the server via RDP.

2. Login to Plesk database by running in CMD the below command:

   MYSQL_WIN: plesk db

3. Select the MSSQL database server id from psa database:

   MYSQL_WIN: mysql> select id from databaseservers where host like '%MSSQLSERVER2012%';
   +----+
   | id |
   +----+
   | 2  |
   +----+
   1 row in set (0.00 sec)

4. Perform the following requests to set default MSSQL ports and version:

   MYSQL_WIN: mysql> update databaseservers set port=1433 where id=2;
   MYSQL_WIN: mysql> update databaseservers set server_version=11.0.6020 where id=2;

5. Refresh Plesk components at Home > Tools&Settings > Server Components > Refresh