Sage Estimating SQL relies on SQL Server connections to facilitate communication between the server and the client. However, when a firewall exists between the client and the server, the firewall must allow incoming traffic to the server on UDP Port 1343 and the TCP listen port assigned to the SQL server instance.
The UDP traffic allows the SQL Server Browser service to listen for connection requests. It then returns the appropriate TCP port for the instance requested. The TCP port is used for query traffic. The TCP port is defined in the SQL Server Configuration Manager, under Network Configuration. By default, the port is dynamically assigned at the time the instance service starts; but this should be statically assigned when working with a firewall (the exception being Windows Defender Firewall having the ability to allow the application access rather than specifying a port) to ensure the rules are always valid.
To update, follow the steps below:
1. Open SQL Server Configuration Manager.
2. Expand the "SQL Server Network Configuration" tree.
3. Click on "Protocols for [INSTANCE NAME]" for the instance that matches the targeted Estimating instance.
4. Right click on "TCP/IP" and choose properties.
5. Open the "IP Addresses" tab and scroll to the bottom.
6. Update the "TCP Port" field to match the value in "TCP Dynamic Ports" (or assign another valid, open port).
7. Click Apply.
8. Update the firewall rules to allow incoming UDP traffic on port 1343 and incoming TCP traffic on the port (assigned in step 6) for the SQL Server.