Home Forums Article Discussions Article Discussions by Author Discuss content posted by Rudy Panigas SQL Server Port Number Identifier RE: SQL Server Port Number Identifier

  • May 24, 2011 at 1:32 am

    #1328858

    M A Srinivas (5/24/2011)

    When I run on my instance (dynamic port) this gives null . Not much use

    Following gives the port

    declare @tcpport varchar(1000),@value varchar(250);set @tcpport = 'SOFTWARE\Microsoft\Microsoft SQL Server\' + @@servicename + '\MSSQLServer\SuperSocketNetLib\Tcp';EXEC master..xp_regread @rootkey = 'HKEY_LOCAL_MACHINE', @key = @tcpport, @value_name = 'tcpPort', @value = @value OUTPUT;select @value

    Did you use the script for right version?

    Have you given correct file paths. Also check the select @value

    Try this

    declare @tcpport varchar(1000),@value varchar(250);

    set @tcpport = 'SOFTWARE\Microsoft\MSSQLServer\' + @@servicename + '\MSSQLServer\SuperSocketNetLib\Tcp';EXEC master..xp_regread @rootkey = 'HKEY_LOCAL_MACHINE', @key = @tcpport, @value_name = 'tcpPort', @value = @value OUTPUT;

    select @value

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/