Knowledge Base

Plesk database servers menu shows warning: Unable to determine the TCP port number used by Microsoft SQL server ‘localhost’

Symptoms

The following warning is shown at Tools & Settings > Database servers:

Warning: Unable to determine the TCP port number used by Microsoft SQL server 'localhost': TCP/IP protocol is not enabled in the server network configuration or the server is configured to use dynamic TCP ports.
To allow your customers to automatically configure firewall for remote database access, manually configure the SQL server to listen on a specific fixed TCP port.
The static port is properly configured in SQL Server 20XX Configuration Manager with enabled TCP/IP protocol.

Cause

The separate port field is currently not used for MSSQL database connections. If the port was specified inside the host field, then such a string is passed like "localhost,1433" into the MSSQL driver, and the driver will use this host for connections.

Bad error reporting bug with ID PPPM-13410 was submitted to improve it.