Error: 'Unable to connect to payroll database XXX"

Summary

Sage HRMS payroll shows a connection error when the system can’t recognize the SQL Server. Sage HRMS requires database connections that reference the SQL Server IP address.

Cause

An unknown DNS issue prevents the network from resolving the SQL Server name or instance name.

Resolution

Follow these steps to resolve the issue:

  1. Uninstall the Sage HRMS client from the affected machine
  2. Update DBCONNECT to reflect the SQL Server IP Address instead of the Server Name and 'Save' the changes
  3. Access Sage HRMS Payroll Database Setup
  4. Update all database connections to use the SQL Server IP Address instead of the SQL Server Name
  5. Reinstall the Sage HRMS client using a UNC path that references the application server IP. Example: \\10.123.45.678\SageHRMSServer\

Need more help?

Chat now

 

Solution Properties

Solution ID
225924550092300
Last Modified Date
Wed May 27 16:44:08 UTC 2026
Views
0