How can you find sql server port number from windows registry
How can you find sql server port number from windows registry
SQL Server 2000
Default instance
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServerMSSQLServerSuperSocketNetLibTCP
Named instance
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server(InstanceName)MSSQLServerSuperSocketNetLibTCP
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_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerMSSQL.#
'#' 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_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerMSSQL.#MSSQLServerSuperSocketNetLibTCPIPAll
SQL Server 2008
Default instance
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerMSSQL10.MSSQLSERVERMSSQLServerSuperSocketNetLibTCPIPAll
Named instance
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerMSSQL10.(InstanceName)MSSQLServerSuperSocketNetLibTCPIPAll
SQL Server 2000
Default instance
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServerMSSQLServerSuperSocketNetLibTCP
Named instance
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server(InstanceName)MSSQLServerSuperSocketNetLibTCP
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_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerMSSQL.#
'#' 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_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerMSSQL.#MSSQLServerSuperSocketNetLibTCPIPAll
SQL Server 2008
Default instance
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerMSSQL10.MSSQLSERVERMSSQLServerSuperSocketNetLibTCPIPAll
Named instance
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerMSSQL10.(InstanceName)MSSQLServerSuperSocketNetLibTCPIPAll
Comments
Write the first comment
Leave a trace
Post being viewed right now
