How to Identify port number of SQL server

Question

I Install SQL server in my system and I have to check on which port number SQL is working in my system

Answer 1

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

The above query shows the local IP as well as the listening Port number

Answer 2

1. Open Run in your system.

2. Type %windir%\System32\cliconfg.exe

3. Click on ok button then check that the "TCP/IP Network Protocol Default Value Setup" pop-up is open.

4. Highlight TCP/IP under the Enabled protocols window.

5. Click the Properties button.

6. Enter the new port number, then click OK.