The steps below can be used to find the TCP Dynamic Port number or port number for both Sage 100 Contractor and Foundation (On-Premise).
You may need to consult your IT team member to assist with locating this information.
Getting Your SQL Server Port
Sage 100 Contractor or Foundation is often configured to use dynamic ports instead of the standard 1433 port used for SQL servers. To confirm the port number that is being used for your Sage or Foundation instance:
Launch the “SQL Server 2014 Configuration Manager” App
Right-click on the SQL Server Network Configuration > Protocols for SAGE100CON > TCP/IP item and select ‘Properties’
Now select the ‘IP Addresses’ tab.
Now scroll down to the IPAll section. If the “TCP Dynamic Ports” section has a number your instance is using dynamic ports, please record that number as it will be required for the final network configuration step. If a number is missing, please record that fact and assume the port that will be used for your SQL server will be 1433.