How to port no on Sql server

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 1

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

sam king SSC-Addicted Points: 479 More actions · Answer 2

thanks a lot

Regards,
SAM
***Share your knowledge.It’s a way to achieve immortality----Dalai Lama***

SQLAli Ten Centuries Points: 1079 More actions · Answer 3

Below are the methods to find the Port of SQL Server

1) From the errorlog. I.e sp_readerrorlog

2) From the Client protocols of configuration manager.

Thanks,
I’m nobody but still I’m somebody to someone………….

Loundy SSCertifiable Points: 6080 More actions · Answer 4

samking (9/18/2013)
Can any one know where to find port id in sql server.
I am new to sql server dba ...please help.
Thanks & Regards
shiva

The following query will return the instance and the port number it's listening on:

DECLARE @TcpPort VARCHAR(5)

,@RegKey VARCHAR(100)

IF @@SERVICENAME !='MSSQLSERVER'

BEGIN

SET @RegKey = 'SOFTWARE\Microsoft\Microsoft SQL Server\' + @@SERVICENAME + '\MSSQLServer\SuperSocketNetLib\Tcp'

END

ELSE

BEGIN

SET @RegKey = 'SOFTWARE\MICROSOFT\MSSQLSERVER\MSSQLSERVER\SUPERSOCKETNETLIB\TCP'

END

EXEC master..xp_regread

@rootkey = 'HKEY_LOCAL_MACHINE'

,@key = @RegKey

,@value_name = 'TcpPort'

,@value = @TcpPort OUTPUT

SELECT @TcpPort AS PortNumber

,@@SERVERNAME AS ServerName

,@@SERVICENAME AS ServiceName

[font="Times New Roman"]There's no kill switch on awesome![/font]