How can I find sql server port number from windows registry?

How can I find sql server port number from windows? Is there any generic way to find port number for sql server 2000, 2005 and 2008?

  • SQL Server match two columns by different strings
  • How to stop the execution of a Stored Procedure using SQL Server?
  • Pivot table how to not allow nulls in multiple columns
  • Visual Studio 2010 Data Generation Plan requiring tables for FK reference when no tables even checked
  • An attempt was made to access a socket in a way forbidden by its access permissions
  • FreeTDS - tsql connects, isql fails
  • 3 Solutions collect form web for “How can I find sql server port number from windows registry?”

    SQL Server 2000

    Default instance

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib\TCP
    

    Named instance

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\(InstanceName)\MSSQLServer\SuperSocketNetLib\TCP
    

    SQL Server 2005

    There is no distinction between default and named instances. An instance is assigned a number based on the order it was installed. We first need to locate the registry key for the instance, which looks like

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.#
    

    ‘#’ is the number assigned to the instance. The instance name is stored as the default value for this registry key. For a default instance, it is MSSQLSERVER.

    Once the registry key for the instance is found, we know the TCP/IP registry key is

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.#\MSSQLServer\SuperSocketNetLib\TCP\IPAll
    

    SQL Server 2008

    Default instance

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQLServer\SuperSocketNetLib\TCP\IPAll
    

    Named instance

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.(InstanceName)\MSSQLServer\SuperSocketNetLib\TCP\IPAll
    

    More information here.

    You can also find the port in the SQL Server Configuration Manager:

    • Select Protocols for SQL2008 under SQL server Network Configuration
    • Right click “TCP/IP” -> select Properties
    • Select the IP Addresses-tab
    • In the section IP ALL, you should see the ports

    i’m not sure correct or not, u can use the Server Network Utility from the server and click Properties in TCP/IP for Enabled protocols list.

    or can also check the port number an instance of SQL Server in the error log i.e. 10.0.0.1: 3306, the last 4 digit no after colon is the SQL server listening for the ip add

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.