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