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 "




/******************************************************************************************************
"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]

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

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

    ReplyDelete
  2. This content is simply exciting and creative. I have been deciding on a institutional move and this has helped me with one aspect. Translate Hello to German

    ReplyDelete
  3. This is important, though it's necessary to help you head over to it weblink: is homework illegal in california

    ReplyDelete
  4. Within this template webpage, you will see the right data, that you should keep an eye on across which usually higher-level about attribute. AIOU

    ReplyDelete
  5. I use only high quality materials - you can see them at: Best Essay Writing Service UK

    ReplyDelete
  6. For as long as I can remember they have talked about Special comptia forum reform and what it's going to mean to us. Today, it's no different. Only the names have changed, and today's name is full-inclusion.

    ReplyDelete
  7. I wanted to thank you for this excellent read!! I definitely loved every little bit of it. I have you bookmarked your site to check out the new stuff you post مسلسلات رمضان 2022

    ReplyDelete
  8. That game is Scrolls, one that Mojang would likely rather forget.Gaming

    ReplyDelete
  9. This is exciting, nevertheless it is vital for you to visit this specific url: research paper writing service

    ReplyDelete
  10. I recommend only good and reliable information, so see it: Minecraft servers

    ReplyDelete

Please do not enter spam links

Meet US

Services

More Services