Below are some ports that you will need to open to allow communication with specific SQL server Services. It’s highly recommended to have all the ports closed by default and to just open each port only when it is actually require by a specific service.
| Service/Feature/Component | Ports |
| Default SQL Instance | 1433 |
| SQL Browser service | UDP 1434 |
| T-SQL debugger | TCP 135 |
| Analysis Services | TCP 2382 |
| Integration Services Runtime | TCP 135 |
| WMI (Windows Management Instrumentation) | TCP 135 |
| MSDTC (Microsoft Distributed Transaction Coordinator) | TCP 135 |
0 Comments