Most of us know the default port for SQL Server is 1433, but there are various ports being used by SQL Server for other database services and SQL features.
In the below table I tried to list the ports that are frequently used by the Database Engine
Item | Port |
Default instance | TCP port 1433 |
Named instance in default configuration | Dynamic port. You can configure named instances to use fixed TCP ports |
Dedicated Admin Connection (DAC) | TCP port 1434 |
SQL Server Browser service | UDP port 1434 |
SQL Server instance running over an HTTP end-point | TCP port 80 for CLEAR_PORT traffic TCP port 443 for SSL_PORT traffic |
Service Broker | TCP port 4022 |
Replication | TCP port 1433 for default instance |
Transact-SQL Debugger | TCP port 135 |
Analysis Services | TCP port 2383 for default instance |
Reporting Services Web Services | TCP port 80 |
Reporting Services configured for use through HTTPS | TCP port 443 |
Integration Services: Microsoft remote procedure calls |
TCP port 135 |
Integration services run time | TCP port 135 |
Microsoft Distributed Transaction Coordinator (MS DTC) | TCP port 135 |
SQL Server Management Studio browse connection to browser service | UDP port 1434 |
You can find more information about the TCP and UDP ports SQL Server uses from books online here: Configure the Windows Firewall to Allow SQL Server Access