Service |
Protocol |
Port |
Description |
Default Instance |
TCP |
1433 |
Default Port for Default Instance |
Default Instance (only for Admin) |
TCP |
1434 |
Admin Port for Default Instance |
SQL Server Browser Service |
UDP |
1434 |
Used by SQL Server Browser if Named Instance is used |
HTTP Connection |
TCP |
80 |
HTTP Connection Port (Database Engine, Analysis Services, Reporting Services) |
HTTPS Connection |
TCP |
443 |
HTTPS Connection Port (Database Engine, Analysis Services, Reporting Services) |
Service Broker |
TCP |
4022 |
Not the default port but used in Books Online examples |
Database Mirroring |
TCP |
5022 or 7022 |
Not the default port but used for Database Mirroring by Default Instance |
Transact-SQL Debugger |
TCP |
135 |
Transact-SQL Debug Port |
Analysis Services |
TCP |
2383 |
Default Port used by Default Instance |
SQL Server Browser Service |
TCP |
2382 |
Used by Named Instance for Analysis Services |
Integration Services |
TCP |
135 |
Integration Services use DCOM on Port 135 |