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]

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

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

    ReplyDelete
  2. There has been a ton of compromising or possibly I should say pulling and pushing with regards to educational strategy, and the educational practices and administrations of education and custom curriculum by the human instructors who convey those administrations on the two sides of the isle, similar to me.

    ReplyDelete
  3. Hare, we provide online free course udemy free course udemy coupons, and free online classes

    https://freecoursewebsite.com

    ReplyDelete
  4. This is my first time visit to your blog and I am very interested in the articles that you serve. Provide enough knowledge for me. Thank you for sharing useful and don't forget, keep sharing useful info: cause and effect examples sentences

    ReplyDelete
  5. Thanks for the blog loaded with so many information. Stopping by your blog helped me to get what I was looking for. cause and effect definition

    ReplyDelete
  6. Positive site, where did u come up with the information on this posting? I'm pleased I discovered it though, ill be checking back soon to find out what additional posts you include. Study Bachelors of Engineering in Software Engineering from Thompson Rivers University, Canada

    ReplyDelete
  7. Thanks for making me to gain new suggestions about computers. I also have belief that certain of the best ways to help keep your mobile computer in primary condition is by using a hard plastic material case, as well as shell, that matches over the top of one’s computer. Most of these protective gear tend to be model unique since they are made to fit perfectly in the natural covering. You can buy them directly from owner, or via third party sources if they are available for your notebook computer, however its not all laptop can have a spend on the market. Once more, thanks for your guidelines. weblink

    ReplyDelete
  8. I know it’s a drastic situation and you have to think on your toes, but you will surely die if you do what you’re thinking of doing. check over here

    ReplyDelete

Please do not enter spam links

Services

More Services