Applicable to:
- Plesk Onyx for Windows
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
-
Connect to the server via RDP.
-
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) -
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; -
Refresh Plesk components at Home > Tools&Settings > Server Components > Refresh
Comments
0 comments
Please sign in to leave a comment.