Finding port numbers

Question

Post reply

Finding port numbers

sravanthiyerramreddy86

SSC Veteran

Points: 254
More actions
January 17, 2011 at 3:24 am

#245368

Hi,
can any one tell me the script for finding the port number of sqlserver

Viewing 7 posts - 1 through 6 (of 6 total)

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

crazy4sql SSCoach Points: 19590 More actions · Answer 1

http://decipherinfosys.wordpress.com/2008/01/02/finding-the-port-number-for-a-particular-sql-server-instance/

----------
Ashish

D Gillespie Old Hand Points: 387 More actions · Answer 2

Here is a good source for the SQL Script:

http://www.sqlservercentral.com/scripts/Miscellaneous/67422/

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 3

sravanthiyerramreddy86 (1/17/2011)
Hi,
can any one tell me the script for finding the port number of sqlserver

Easy way to find the port number

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

SQListic SSCertifiable Points: 6904 More actions · Answer 4

Hope this link helps you

http://sqlism.blogspot.com/2012/08/finding-port-number-for-particular-sql.html

Finding the Port Number for a particular SQL Server Instance

DECLARE @tcp_port nvarchar(5)

EXEC xp_regread

@rootkey = ‘HKEY_LOCAL_MACHINE’,

@key = ‘SOFTWARE\MICROSOFT\MSSQLSERVER\MSSQLSERVER\SUPERSOCKETNETLIB\TCP’,

@value_name = ‘TcpPort’,

@value = @tcp_port OUTPUT

select @tcp_port

Perry Whittle SSC Guru Points: 234013 More actions · Answer 5

Sqlism (9/12/2012)
Hope this link helps you
http://sqlism.blogspot.com/2012/08/finding-port-number-for-particular-sql.html
Finding the Port Number for a particular SQL Server Instance
DECLARE @tcp_port nvarchar(5)
EXEC xp_regread
@rootkey = ‘HKEY_LOCAL_MACHINE’,
@key = ‘SOFTWARE\MICROSOFT\MSSQLSERVER\MSSQLSERVER\SUPERSOCKETNETLIB\TCP’,
@value_name = ‘TcpPort’,
@value = @tcp_port OUTPUT
select @tcp_port

This is not correct for a SQL Server 2005 onwards instance. Enumerate instance names from

HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\Instance names\SQL

Then for each instance found get the 'TcpPort' value from (SQL Server 2008R2 example)

HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\MSSQL10_50.instancename\MSSQLSERVER\SuperSocketNetLib\Tcp\IPAll

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

SQListic SSCertifiable Points: 6904 More actions · Answer 6

SQListic

SSCertifiable

Points: 6904

September 13, 2012 at 9:45 am

#1537301

Perry-Thanks for correcting me 🙂