How to Get SQL Server Port Number from Registry

– SQL 2005 and 2008
declare @SmoDefaultFile nvarchar(512)
exec master.dbo.xp_instance_regread N’HKEY_LOCAL_MACHINE’,
N’Software\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib\Tcp\IPAll\’, N’TcpPort’,
@SmoDefaultFile OUTPUT
print @SmoDefaultFile
——————
– SQL 2000 and SQL 7
declare @SmoDefaultFile nvarchar(512)
exec master.dbo.xp_instance_regread N’HKEY_LOCAL_MACHINE’,
N’SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib\Tcp’, N’TcpPort’,
@SmoDefaultFile OUTPUT
print @SmoDefaultFile
————————————
– SQL 2005 and 2008 dynamic ports
declare @SmoDefaultFile nvarchar(512)
exec master.dbo.xp_instance_regread N’HKEY_LOCAL_MACHINE’,
N’Software\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib\Tcp\IPAll\’, N’TcpDynamicPorts’,
@SmoDefaultFile OUTPUT
print @SmoDefaultFile