• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Database server warning after Plesk Panel upgrade

MolenoM

New Pleskian
After Plesk Panel upgrade to 12.x I found a warning showing at Home>Tools & Settings> Database Servers

Warning: Unable to determine the TCP port number used by Microsoft SQL server '.\SQLEXPRESS': 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.

What should I do to fix it ?
 
Just use hint from this warning:

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.
 
issue seems to be mssql port, login server using rdp >> sql server configuration >> network >> go to properties and check port 1433 is present under server IP. Also check if your firewall allows port 1433. To check it you can use command telnet server IP 1433 from your local machine. Check if it connects
 
Back
Top