Setting Up Database Configuration
Use Database Configuration to specify the Sage HRMS database before you complete the Employer Configuration or Employee Configuration.
To Configure the Database
- Select Setup > Payroll > Database Setup > Database Configuration.
- In the Sage HRMS SQL Server Name field, enter or select the machine where Sage HRMS Server is installed.
- In the Sage HRMS Database Name field, enter the name of the following databases from where the employee information will be transferred into Payroll.
- SageHRMS_Live for the live database
- SageHRMS_DEU for the U.S. Payroll sample database (if using 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.
- Enter the SQL logon credentials in the Database User and Database Password fields.
- Click Test Connection to ensure the database connections are successful.
- Click Save to save the database connection information and close the window.