SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

SQL Server Blog Forum

My name is Muthukkumaran Kaliyamoorthy and I am living in India (Chennai). I’m currently working as a SQL server DBA in one of the top MNC. I’m passionate about SQL Server, and I’m specialized in Administration and Performance tuning.

How to find the SQL server port number


One day I got a call from my junior DBA. She asked me, how can I find out the port number for a particular server? Then our conversation started,


I asked a question to her what version of SQL server is that.

Junior DBA:

Its SQL server 2005


I told her to check the configuration manager.

Start –> all programs –> Microsoft SQL server 2005 –> Configuration Tools –> SQL server

Configuration Manager.


Junior DBA:

I don’t have direct remote access. (MSTSC)


After that, I told to check the SQL error log by using T-SQL



SP_readerrorlog 0,1,'listening','server'

Junior DBA:

I didn’t see ‘’listening’ such a word.

(0 row(s) affected)



Again I told to change the first parameter 0 to 1.

sp_readerrorlog 1,1,'listening','server'

Junior DBA:

Yep, I got it.


2011-01-19 11:36:23.340        Server Server is listening on [ ‘any’ <ipv6> 1433].

2011-01-19 11:36:23.340        Server Server is listening on [ ‘any’ <ipv4> 1433].

Here is another one method,
(For default instance)


CREATE PROCEDURE usp_getport_number
DECLARE @findport_number nvarchar(5)
EXEC xp_regread
@rootkey    =    'HKEY_LOCAL_MACHINE',
@value_name    =    'TcpPort',
@value        =    @findport_number OUTPUT
print 'The server port number = '+@findport_number

EXEC usp_getport_number


Leave a comment on the original post [www.sqlserverblogforum.com, opens in a new window]

Loading comments...