Skip to content
logo Knowledgebase

Error: 'Unable to connect to payroll database XXX"

Created on  | Last modified on 

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