Move Sage HRMS to a new server

1. When moving both servers, back up the Sage HRMS SQL databases.
2. When moving the HRMS server, ensure it can access the existing SQL server.
3. Use SQL Management Studio to back up SageHRMS_Live and all payroll databases (Company, SYS, Vault, Store) externally.
4. After creating backups, copy the *.BAK files to a network or external drive accessible to the new server.
5. Restore the .bak files to the new SQL server location on the new server.
6. Download the Sage HRMS install files and the latest quarterly update from the Sage Knowledgebase.
7. The new installation will prompt for the Serial Number and Installation code. You can find this on the old installation by clicking the green '?' icon and selecting About Sage HRMS. The Serial Number and Installation Code will be on the pop-up screen. Copy these down to use during the installation.
8. Note the Sharing and Security settings of the C:\ProgramData\Sage\SageHRMSServer folder to replicate on the new server.
9. Uninstall the Sage HRMS Client from the workstation before the upgrade.
10. Install the latest, full-build version of Sage HRMS on the new server. 
11. During installation:
    • Enter the SQL server IP and sa password (or other full-permission credentials) on the database connection screen.
12. The installer prompts you to reboot the server after installation.
13. Ensure all users log off to prevent data loss or program issues.
14. On the new server:
    • Use the database setup tool to connect to the HRMS payroll database using the credentials from step 11.
15. Install the latest Sage HRMS quarterly product update.
16. When the update is complete, click the new desktop icon that reads SageHRMS Client Install.
17. After the client installs:
    • Log in with your Sage HRMS credentials
    • Click OK when prompted to update files for the new version
18. Verify users can log in and see current data in Sage HRMS.
19. Make sure the SageHRMSServer folder has all the needed permission as the previous install.
20. Install the local workstation client from the UNC path \ProgramData\Sage\SageHRMSServer\Client and run setup.exe as administrator.
21. Launch the clients on the workstation and be sure end users can see current data. Launch the client and you receive a message Unable to connect to payroll database 'XXX' see article 240326135020393.

If a non-master user sees the error 'Unable to connect to Payroll database ‘XXX’"

• Move them to the Master group in Sage HRMS User Security
• Then back to their original non-master group