Firewalls help protect the surface area of the SQL Server and prevent unauthorized access to resources. Listed below are some common SQL Server ports to configure for Windows Firewall.
Ports should only be opened if the specific services are needed. You can configure the ports using the SQL Server Configuration Manager tool.
|
Description
|
Protocol
|
Port
|
|---|---|---|
| Database Engine (default instance) | TCP | 1433 |
| Database Engine (default instance) | UDP | 1434 |
| Database Mail | SMTP | 25 |
| Database Mirroring | TCP | No official default port, but examples tend to use 5022. |
| Dedicated Administrative Connection (default instance) | TCP | 1434 |
| Filestream | TCP | 139 and 445 |
| Service Broker | TCP | No official default port, but examples tend to use 4022. |
| SQL Server Browser Service | UDP/TCP | UDP: 1434 TCP: 2382 |
| SQL Server (default instance) over HTTP | TCP | 80 |
| SQL Server (default instance) over HTTPS | TCP | 443 |
| SQL Server Integration Services | TCP | 135 |
| TSQL Debugger | TCP | 135 |
Related Courses:
Administering Microsoft SQL Server 2012 Databases (M10775)
MCSA: SQL Server 2012 Boot Camp
SQL Server 2008 R2 for Administration (M6231)
Please support our Sponsors here :