Verifying the configuration of a SQL Server port is a two-step process:
Related Documentation: SQL Server Locks and Configuring SQL Server Ports
To find the TCP/IP port of a SQL Server instance:
Use master Go Xp_readerrorlog |
To verify the port configuration of a SQL Server instance:
HKEY_LOCAL_MACHINESOFTWAREMicrosoft Microsoft SQL Server MSSQLServerSuperSocketNetLibTcp
The TCPDynamicPorts and TCPPort values appear as follows, depending on your port allocation method:
If you configure an instance of SQL Server to use a static port, and you have not yet restarted the SQL Server instance, the registry values are set as follows:
TCPDynamicPorts = Last port used
TCPPort = New static port that you set by using the Server Network Utility.
If you configure an instance of SQL Server to use a static port, and you restart the SQL Server instance, the registry values are set as:
TCPDynamicPorts = Blank
TCPPort = New static port that you set by using the Server Network Utility.
If you configure an instance of SQL Server to use dynamic port allocation, and you have not yet restarted the SQL Server instance, the registry values are set as follows:
TCPDynamicPorts = Blank
TCPPort = 0
However, if you configure an instance of SQL Server to use dynamic port allocation, and you restart the SQL Server instance, the registry values are set as follows:
TCPDynamicPorts = Current port used
TCPPort = Current port used