Database server warning after Plesk Panel upgrade

[MolenoM]

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 ?

 

[IgorG]

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.

 

[IgorG]

For example - http://blogs.msdn.com/b/arvindsh/ar...amed-instance-and-avoid-a-common-pitfall.aspx

 

[24x7serversupports]

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