Blog Post

Find the TCP port used by a named instance

,

We know for SQL Server default instance, if TCP/IP protocol is used, the default TCP port number is always 1433. However for a named instance, the TCP port number is dynamic but sometimes, we need to know this port number for various reasons. I find the following way is probably the easiest one:

1. Open a query window from SSMS to connect to the instance of interest.

2. Run:

select local_net_address, local_tcp_port
from sys.dm_exec_connections
where session_id = @@spid

and you get the IP address of the server where the instance resides and the tcp port that is used by the instance.

Rate

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

Share

Share

Rate

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating