How to identify port number of SQL Server

Microsoft

In order to identify what port number is SQL Server using, follow the instructions below:

1.Open SQL Server Management Studio
2.Connect to the database engine for which you need the port number
3.Run the below query against the database:

select distinct local_net_addresslocal_tcp_port from sys.dm_exec_connections where local_net_address is not null 

Then click run.

Was this article helpful?

Leave A Comment?