How to find Sql Server Port


Identifying the SQL Server Port in Microsoft Sql Server

1. To find Port no. in Sql Server 2000 goto Server Network Utility



2. To find Port no. Sql Server 2005 & Above goto Sql Server Configuration Manager





3.
To find Port no. from Query Analyzer :
"Query the Registry Keys from Query Analyzer "




/******************************************************************************************************
/
DECLARE @test varchar(20) ,@key varchar(100)
if charindex('\',@@servername,0) <>0
BEGIN
set @key = 'SOFTWARE\MICROSOFT\Microsoft SQL Server\'+@@servicename+'\MSSQLServer\Supersocketnetlib\TCP'
END
ELSE
BEGIN
set @key = 'SOFTWARE\MICROSOFT\MSSQLServer\MSSQLServer\Supersocketnetlib\TCP'
END
EXEC master..xp_regread @rootkey='HKEY_LOCAL_MACHINE',@key=@key,@value_name='Tcpport',@value=@test OUTPUT

SELECT @@ServerName,convert(varchar(10),@test)as [Port Number]

/******************************************************************************************************/

1 comment:

  1. Earn $3 for every click
    http://www.richptc.me/index.php?ref=Summer

    ReplyDelete