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 your network. Contact your system administrator for assistance. Modifying Windows security incorrectly can severely affect system operations. Sage is not responsible for operation issues caused by incorrectly modifying your Windows security. Always create a backup of your data before proceeding with advanced solutions. 
CAUTION: Sage Customer Support does not assist with issues related to third-party products or enhancements, hardware, report customizations, state or federal tax-related questions, or specific accounting questions. Please get in touch with your Sage business partner, network administrator, or accountant for assistance. Please refer to our Scope of Support document for details.

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