Configuring Access to Sage 100 Contractor

Creating a SQL Server User and provisioning access to the Sage 100 API are essential steps to enabling your integration.

You must be a Sage 100 administrator to complete these steps.

Create a SQL User

1. Select Start Database Administration in the bottom right to open the Database Administration tool. If you do not see this option, log into Sage 100 with Administrator rights.
2. Navigate to Company Admins / SQL Logins > Add SQL Server Login.
   1. Select Authentication = SQL Server Authentication
   2. Enter API-User as your login and create a secure password in the password field.
   3. Check Add as member of the ‘sysadmin’ server role.
   4. Select Create SQL Login.
3. Navigate to Add Company Administrator.
   1. Assign API-User to the Sage 100 company you intend to integrate.
4. Navigate to Modify SQL Server Administrators and confirm API-User is listed as a sysadmin with the box checked. If not, check the box and hit Save.
5. Close the Database Administration tool and return to Sage 100.

To enable API Access

1. In Sage 100 Contractor SQL, select main menu option 7-2-1 Security Groups.
2. In 7-2-1 Security Groups, create a group named API, making sure the group number you assign is unique.
3. In 7-2-1 Security Groups, assign the appropriate level of access rights to the API group.
   1. Save = Yes
   2. Delete = Yes
   3. Select the Save icon.
4. In Sage 100 Contractor SQL, select main menu option 7-2-2 User List.
5. Create an entry with the user name API-User and add it to the API group that you just created. The user name must exactly match the user name created in step 2- Create a SQL User. Do not click the Password column or modify any other columns. Select the Save icon.