Work with your IT professional to ensure you configure your firewall properly.

Ports

UDP Ports

• 1433-1435, 5093, 6001, 7001

TCP Ports

• 25, 80, 137-139, 443, 515, 1583, 3351, 8101-8102, 11486-11488,1433, 6002, 7001, 7002, 8004, 8005, 50524, 50525, 62200-62600

Required rules

Configure the following rules to ensure your workstation can communicate with your SQL Server instance.

• The SQL Server Database Engine service: Inbound Rule: Program: %ProgramFiles%\Microsoft SQL Server\ \MSSQL\Binn\sqlservr.exe
• The SQL Server browser service: Inbound Rule: Port: 1433
• Add SQL TCP Dynamic Ports: You can find this in SQL Server Configuration Manager