Failover configuration with a remote SQL Server
- Last Updated: May 21, 2025
- 3 minute read
- MOVEit Automation
- Version 2026
- Documentation
Before you proceed, make sure that the previous assumptions are met.
- Primary node: Install MOVEit Automation.
- Select the account type you would like to use: GMSA/Windows/Virtual Account with SQL Authentication or Windows Authentication (GMSA/Windows Accounts only).
- SQL Authentication is only permitted when using Virtual Account type. If using SQL Authentication, enter the user you would like the installer to create, for example, moveitautomation.
- Enter the details of the remote SQL Server and the database name you would like to use, for example, micstats.
- If using SQL Authentication, enter the user you would like the installer to create, for example moveitautomation.
- Secondary node: Install MOVEit Automation.
- Select the account type you would like to use: GMSA/Windows/Virtual Account with SQL Authentication or Windows Authentication (GMSA/Windows Accounts only). If using GMSA, ensure the same GMSA is used on both nodes.
- If using Windows Authentication with a Windows Account, ensure the same Active Directory account is used, or the Windows Account exists on the SQL Server and both MOVEit Automation nodes with the same password.
- Enter the details of the remote SQL Server and the database name you would like to use, for example, micstats.
- If using SQL Authentication, enter a temporary user that the installer will create, for example, moveitautomation_del .
- Both nodes: Stop the MOVEit Automation Service.
- Both nodes: Open the registry editor and navigate to
HKEY_LOCAL_MACHINE\Software\Standard Networks\MOVEit Central\Resil.
Enter
SuppressDbRep=1. Create a newDWORDnamedSuppressDbRepwith a value of1. - Both nodes: Synchronize the KeyMat registry keys:
- Export the
KeyMatregistry key from the primary node and import it into the secondary node. - Export the
KeyMatregistry key from the secondary node and import it into the primary node.
- Export the
- Both nodes: Create a new local user named automationfailover and
add it to the MOVEit Admins group. Or use an Active Directory user. Below is a sample
PowerShell script to create a local
user:
$pass = ConvertTo-SecureString “<enter password here>” -AsPlainText -Force New-LocalUser “automationfailover” -Password $pass -PasswordNeverExpires Add-LocalGroupMember -Group “MOVEit Admin” -Member “automationfailover” - Primary node: Open the Failover Tab and configure the following
information:
- This Node - Startup Role: Primary
- This Node - Node Number: 1
- This Node - Nodes to ping: (Optional: usually the IP address of trusted router, leave blank if unsure)
- Other Node - Hostname or IP: [IP Address of Node #2]
- Other Node - MOVEit Admin user: automationfailover
- Other Node - Password: [automationfailover's Password]
- Click Apply.
- Secondary node: Open the Failover Tab and configure the following
information:
- This Node - Startup Role: Secondary
- This Node - Node Number: 2
- This Node - Nodes to ping: (Optional: usually the IP address of trusted router, leave blank if unsure)
- Other Node - Hostname or IP: [IP Address of Node #1]
- Other Node - MOVEit Admin user: automationfailover
- Other Node - Password: [automationfailover's Password]
- Click Apply.
- Secondary node: Update the database details:
- Open the
- Update the database name and credentials (if applicable) to match the primary node.
- Click Apply.
- Primary node: Start the MOVEit Automation service. From a command line, you may use the command net start moveitautomation.
- Secondary node: Start the MOVEit Automation service. From a command line, you may use the command net start moveitautomation.
- Primary node: Open MOVEit Automation Web Admin and log on. Check the status on the dialog. This should show that the Primary node is the primary MOVEit Automation node, and the Secondary node is the secondary MOVEit Automation node.
- Primary node: Use the MOVEit Automation Web Admin menu item to reset tamper detection for the failover system.
- SQL Server:
- Once you have confirmed everything is operational, delete the Database created in step 2 above.
- If using SQL authentication, delete the SQL user created in step 2 above.
- Reset the moveit_installer user password.
- Both nodes: If the SQL Server is running in Mixed Mode.
- Open the Config Utility and enter the new password