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_address, local_tcp_port from sys.dm_exec_connections where local_net_address is not null
Then click run.
Leave A Comment?