All Collections
For Administrators
Integrations
Sage 100
How To Share Your Sage 100 Server Access Details
How To Share Your Sage 100 Server Access Details

A guide on how to find the server access details to provide to Workyard to enable your connection

Alex avatar
Written by Alex
Updated over a week ago

With the Workyard and Sage 100 Contractor integration, you can easily map your Sage employees, jobs, and cost codes to your employees, projects and cost codes in Workyard. This allows you to export timesheets to Sage 100 for payroll, invoicing, and job costing.

How It Works

Part 1 - Set Up An API User In Sage

  1. Launch Sage 100 Contractor.

  2. After you launch Sage 100, you’ll be asked to select your company database:

  3. Record your exact company name including any spaces between words. Workyard will need this name to connect to your Sage database. In the above example, the name is “Sample Company”.

  4. Then click on, 7 - Utilities -> Company Security -> Security Groups:

  5. Add an ‘API’ security group with the settings in the image below:

  6. Next double click on 7 - Utilities -> Company Security -> Users List and add an “API” user and add them to the newly created "API" security group per the image below. Make sure Integrated Security is set to No and you specify a password with at least 10 characters and at least one number. Write down the password used as you will need to provide that back to the Workyard support team.

Part 2 - Sage Server Configuration

  1. Launch the “Database Administration for Sage 100 Contractor SQL” app.

  2. Click on Advanced Settings -> Advanced SQL Server Settings

  3. Make sure “Enable other machines to connect to the SQL Server Instance” is checked

  4. Make sure both the options that start with “Limit access” are unchecked as follows:

Part 3 - Getting Your SQL Server Port

Sage 100 contractor 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 instance:

  1. Launch the “SQL Server 2014 Configuration Manager” App

  2. Right click on the SQL Server Network Configuration -> Protocols for SAGE100CON -> TCP/IP item and select ‘Properties’

  3. Now select the ‘IP Addresses’ tab.

  4. 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.

Part 4 - Configuring Network Access

If you are using a firewall, you’ll need to enable access for Workyard servers to connect to your Sage installation:

  1. Enable access for 52.165.208.52 (Workyard IP) to be able to connect to your Sage machines Public IP Address on the port you collected in Part 3.4 of this guide.

Part 5 - Provide Workyard With Server Access Details

The final step is to complete the Sage 100 Integration Setup Form. This will provide the necessary details for Workyard to set up an integration. Once completed and submitted, a Workyard Support team member will reach out to you directly with the next steps.


Our customer support team is always here to help if you have questions or would like some help. Contact us at help@workyard.com or message us via the Help icon.

Did this answer your question?