How to Identify port number of SQL server

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