Skip to content
logo Knowledgebase

Sage Estimating SQL firewall ports

Created on  | Last modified on 

Summary

This article can also be used to resolve the error "Unable to update license information: failed to contact Sage. Please check your Internet connection and try again."

Description


Cause


Resolution

 CAUTION: This solution requires advanced knowledge of Windows security and network settings. Sage isn't responsible for any issues that arise from changes to these settings. Ensure you back up all system and application databases necessary for a complete restoration. It's advisable to contact a certified consultant or your system administrator for assistance.
CAUTION: Sage support can't assist with third-party products, hardware, report customizations, or state and federal tax questions. Refer to our Scope of Support for more info. Contact your Sage business partner, network administrator, or accountant for assistance.

Sage Estimating SQL uses the following 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

A workstation will not be able to communicate with your SQL Server instance without these rules.

  • 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

Image