Verifying the configuration of a SQL Server port is a two-step process:

Related Documentation:  SQL Server Locks and Configuring SQL Server Ports 

Finding the TCP/IP Port

To find the TCP/IP port of a SQL Server instance:

    1. Start SQL Query Analyzer, and then connect to the SQL Server instance.
    2. Run the following Transact-SQL statement in SQL Query Analyzer:
       
Use master
Go 
Xp_readerrorlog
  1. In the Results pane, locate the following text:
    SQL server listening on X.X.X.X: Y
    Where X.X.X.X is the IP address of the SQL Server instance and Y is the TCP/IP port on which SQL Server is listening.
    For example, if SQL server is listening on 10.150.158.246: 1433, 10.150.158.246 is the IP address of the SQL Server and 1433 is the TCP/IP port on which the SQL Server instance is listening.

Verifying the Configuration of the Port

To verify the port configuration of a SQL Server instance:

  1. Start the Windows Registry Editor.
  2. In Registry Editor, locate the following registry key:
     HKEY_LOCAL_MACHINESOFTWAREMicrosoft
     Microsoft SQL Server
     MSSQLServerSuperSocketNetLibTcp
     

    The TCPDynamicPorts and TCPPort values appear as follows, depending on your port allocation method: