How to Apply MultiSubNetFailover to the Hub Repository for SQL Server High Availability
Question
How can I enable the MultiSubNetFailover=Yes
setting on the hub repository to support failover in a SQL Server High Availability (HA) setup?
Environment
- HVR 6
- Hub repository running on SQL Server with High Availability (HA)
Answer
To enable SQL Server HA failover support, start the hub server from the command line and set the MultiSubNetFailover=Yes
parameter using the HVR_ODBC_CONNECT_STRING_ADD
environment variable. See the example command below:
hvrhubserver -EHVR_ODBC_CONNECT_STRING_ADD=MultiSubNetFailover=Yes -*arguments
*
If you encounter an error, explicitly set the HVR_HOME
and HVR_CONFIG
environment variables. Use the following command, replacing the placeholders with the appropriate paths:
hvrhubserver -EHVR_HOME=<path_to_hvr_home> -EHVR_CONFIG=<path_to_hvr_config> -EHVR_ODBC_CONNECT_STRING_ADD=MultiSubNetFailover=Yes -acs