Type in the search box firewall and select Windows Firewall with advanced security. Go to Inbound Rules and add the ports one by one:
New Rule → TCP → Specific Local Ports → Next → Domain → Next → Finish
Use these Ports:
| Protocol | Port | Description |
|---|---|---|
| TCP | 135 | Transact SQL Debugger |
| TCP | 1433 | SQL Traffic |
| UDP | 1434 | SQL Browser Traffic |
| TCP | 2383 | SQL Analytics Traffic |
| TCP | 4022 | SQL Broker Traffic |