Counter of Festivals

Ashok Blog for SQL Learners and Beginners and Experts

Thursday, 14 February 2013

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'