3305 Main Street Ste 019 Vancouver, WA 98663

An Error Occurred While Attempting To Retrieve The List of Sage 100 Contractor Databases From The Server

Scenario

When migrating from Sage 100 Contractor 2014 (version 19.x) to 2016 (version 20.x), the underlying database framework changes to Microsoft SQL Server. As there are considerable differences between the previous underlying database framework, Fox Pro, and Microsoft SQL Server, there are certain configurations which can result in the following symptom.

Symptom

When creating a new connection using Liberty Reports to a Sage 100 Contractor 2016 (version 20.x) database, an unexpected situation occurs when attempting to display the list of available Company Files.

This occurence is a direct result of one of the following two changes to Sage 100 Contractor 2016:

  1. Microsoft SQL Server's ODBC driver does not allow for certain special characters in the database name. The FoxPro ODBC driver had no such issue. Using the Sage 100 Contractor migration tool to update from 2014 (version 19.x) to 2016 (version 20.x) does not account for this change.
  2. Sage 100 Contractor 2016 (version 20.x) provides a Database Administration program. This program creates an additional level of security that, in some customer environments, denies access from Liberty Reports to the Microsoft SQL Server instance.

Recommendation

Event 1 Software, Inc. recommends trying the following two Solutions in succession, only moving to Solution 2 if Solution 1 fails to correct the issue.

NOTE - Both solutions require administrative access to the Sage 100 Contractor Database Server.

  • Solution 1
    1. Use Database Administration for Sage 100 Contractor to verify the following special characters do not appear in any Company Name:
      • , (comma)
      • . (period)
      • & (ampersand)
    2. If a special character is discovered, use the Rename Company utility located in the Add / Delete Companies menu of Database Administration for Sage 100 Contractor.
    3. Retry using Liberty Reports to create a connection to your Sage 100 Contractor 2016 (version 20.x) database.
  • Solution 2
    1. In Database Administration for Sage 100 Contractor, open the Advanced Settings menu and select Advanced SQL Server Settings.
    2. Click Edit Approvals and allow a few moments for the list of applications to populate.
    3. Once the list has populated locate the check box that has a blank description and select it.
    4. Click OK.
    5. Click Save Changes.
    6. Retry using Liberty Reports to create a connection to your Sage 100 Contractor 2016 (version 20.x) database.
    7. If still unable to create the connection, go back to Database Administration for Sage 100 Contractor.
    8. Under Advanced Settings...\Advanced SQL Server Settings, clear the check box for Limit Access To This SQL Server Instance To Approved Applications.
    9. Click Save Changes.
    10. Retry using Liberty Reports to create a connection to your Sage 100 Contractor 2016 (version 20.x) database.

If you would like any assistance with either recommended solution, feel free to contact our support team via email support@event1software.com or by phone at 360-567-3752.