SQL Server Configuration Requirements

One or more instances of supported Microsoft SQL Server is installed on each server. For supported SQL servers, see the Arcserve RHA Release Notes.

• Both servers must have the same SQL version, service packs and hot fixes installed.
• Both servers must hold identical SQL server instances (default or named).
• (In the Active Directory environment) Both Master and Replica servers must reside in the same Active Directory forest and be members of the same domain or trusted domains.
• Drive letters containing database files must be identical on both servers.
• The full path to the default system database of each instance must be identical on both servers.
• Verify that the port defined in the Network Configuration TCP/IP properties of the SQL instances is assigned statically and is identical on both Master and Replica.
• SQL Server Configuration Manager: If the server has multiple IP addresses or Move IP redirection is used in RHA scenario, verify that the TCP Port is set and identical, and also TCP Dynamic Ports is blank/empty.

Note: Verify for each IP address (involved in RHA scenario) in SQL Server Configuration Manager's Network Configuration TCP/IP Properties dialog on both Master and Replica(s).

• When the SQL account is Network, make sure that you create a database login for the NT AUthority\Network Service account. See Microsoft documents for more details.