article Verifying the Configuration of SQL Server Ports

Related Documentation Version of up.time affected Affected Platforms
Configuring SQL Server Ports
SQL Server Locks
All All

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

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
    
  3. 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:

    • Static Port Allocation

      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.

    • Dynamic Port Allocation

      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

Related Articles


Configuring SQL Server Ports

RatingViews
article

This article explains how to configure static and dynamic SQL Server ports.

By: uptime Support | Date Created: 7-11-2007 | Last Modified: 6-28-2011 | Index: 193

  8444

Required Ports for the up.time Monitoring Station

RatingViews
article

By: uptime Support | Date Created: 10-28-2005 | Last Modified: 6-26-2013 | Index: 021

  8596

Verifying the Active Directory Group Distinguished Name

RatingViews
article

Best way to determine the setting to use in the AD Group Distinguished Name field is to use the AD Explorer tool by Sysinternals. http://technet.microsoft.com/en-us/sysinternals/bb963907.aspx -...

By: uptime Support | Date Created: 8-13-2010 | Last Modified: 8-13-2011 | Index: 480

  10547

What ports does up.time use?

RatingViews
article

A full list of the required ports for the up.time monitoring station and agent is included in this article: http://support.uptimesoftware.com/article.php?id=021

By: uptime Support | Date Created: 8-5-2010 | Last Modified: 7-7-2011 | Index: 464

  2413

What ports do I need to open for up.time?

RatingViews
article

Information on what ports up.time will use by default can be found here: http://support.uptimesoftware.com/article.php?id=021

By: uptime Support | Date Created: 12-31-1969 | Last Modified: 9-1-2011 | Index: 273

  2843

User Comments



No comments have been posted.

Copyright © 2021 IDERA, Inc.   Legal   Privacy Statement