Setting Up Database Configuration

Use Database Configuration to specify the Sage HRMS database before you perform Employer Configuration or Employee Configuration.

To configure the database

1. Select Setup > Payroll > Database Setup > Database Configuration.
2. For Sage HRMS SQL Server Name, enter or select the machine where Sage HRMS Server is installed.
3. For Sage HRMS Database Name, enter the name of one of the following databases containing the employee information that will be transferred into Payroll.
   • SageHRMS_Live for the live database
   • SageHRMS_DEU for the U.S. Payroll sample database (if U.S. Payroll is installed)
   • SageHRMS_DEC for the Canadian Payroll sample database (if Canadian Payroll is installed)

Note: Periods (.) are not permitted in database names.

4. For Database User and Database Password, enter the SQL logon credentials.
5. Click Test Connection to ensure the database connections are successful.
6. Click Save to save the database configuration information and close the window.