l
Have the Enterprise SQL DB Administrator create a SQL account specifically for the Sage
HRMS database and give that account name to the install team.
l
After the install, have the Enterprise SQL DB Administrator downgrade this account to DB
Owner credentials only. Be advised that the account used during installation is the same
account and password that will be used by the Sage HRMS application. To test this
account and password combination, use the Database Connection Tool.
You can only enter alphanumeric characters (alphabetic characters a-z, A-Z, and numeric
characters 0-9) in fields on the install screens, such as for a company name or server name.
The text cannot contain spaces or special characters (such as #) or punctuation marks.
Verify Database connections
Use the Database Connection Tool to verify the connection to the Sage HRMS database.
1. From the Start menu on the server, select Start > Sage > Database Connection Tool.
2. Review the Server(name), User ID, and Password under SQL Server Settings.
3. Click Test Connections to test for valid connections to the databases.
l
If all connections are successful, the test results display “Successful."
l
If you receive a message that the connections failed, verify that your entries are correct.
4. Click OK to return to the Database Connection Tool window, and then click Save to
establish your database connections.
Review Local Security Policies
Before installing Sage HRMS with Payroll (U.S., Canadian, or both), we recommend that you
review your SQL Server and Local Security Policies on the server where the installation or
upgrade will take place. This should be completed before starting the install process.
Important! Starting with Sage HRMS Q1 2024, user security policies are now enforced
by Windows Account Policies on the machine running MS SQL Server. If you are
upgrading from the Q1 2024 version of Sage HRMS or later and have already updated
your Admin's password to meet the password complexity rules, no changes are
required to the Minimum password age security policy as mentioned below.
10
Sage HRMS Installation
Guide