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

• DSS 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 DSS_ODBC_CONNECT_STRING_ADD environment variable. See the example command below:

dsshubserver -EDSS_ODBC_CONNECT_STRING_ADD=MultiSubNetFailover=Yes -*arguments
*

If you encounter an error, explicitly set the DSS_HOME and DSS_CONFIG environment variables. Use the following command, replacing the placeholders with the appropriate paths:

dsshubserver -EDSS_HOME=<path_to_dss_home> -EDSS_CONFIG=<path_to_dss_config> -EDSS_ODBC_CONNECT_STRING_ADD=MultiSubNetFailover=Yes -acs