To see the Local Port and TCP/IP Address in SQL Server:

To see the Local Port and TCP/IP Address in SQL Server:

Default ports are in table below:

Service             Port    Port type    Note

SQL Server Engine   1433    TCP

SQL Server Browser  1434    UDP

SSAS                2383    TCP

SSAS server Browser 2382    UDP

SSIS                135     TCP          Cannot be changed

SSRS                80      TCP 

However those are default ports. If you run named instances, than by default htose instances are running on dynamic ports, which can be changed to fixed one in the SQL Server Configuration manager.

You can see which address & port an instance of SQL Server is running with the following bit of code:

select distinct local_net_address, local_tcp_port

from sys.dm_exec_connections

where net_transport = 'TCP'