Find SQL Server Port Number: Quick Guide

To view the port number of the SQL Server instance, you can use one of the following methods:

1. Utilizing SQL Server Configuration Manager:

1. Open SQL Server Configuration Manager.
2. Select SQL Server Network Configuration in the left-hand panel.
3. Choose the example you want to view the port number.
4. On the right panel, you can see the port number that is being used in this instance.

1. Using SQL Server Management Studio:

1. Connect to the SQL Server instance.
2. Right-click on the instance in the Object Explorer and select Properties.
3. Select the “Connections” tab in the properties window.
4. In the IP address section, you can see the port number used by the instance.

1. Query using Transact-SQL:

1. Open up SQL Server Management Studio
2. Connect to the SQL Server instance.
3. Execute the following query:

SELECT DISTINCT(local_net_address), local_tcp_port
FROM sys.dm_exec_connections

This will return the port number currently being used by the SQL Server instance.