Add support for multi-subnet failover on MS SQL Always On feature

Idea created by Maheshwar_Kusuma Employee on Jun 4, 2018
    Under review
    • joe.gavan
    • Maheshwar_Kusuma
    • Chi_Chen
    • thauma
    • Chris.Seymour
    • jmayer

    Our Service Desk Manager is configured for Advanced Availability in a windows environment.

    The database is connecting to a SQL Server availability group listener where each failover cluster node is connected to a different subnet.


    To ensure the system works correctly I'm told that we need to specify: "MultiSubnetFailover=True" parameter in the connection string. The connection string is created by SDM.


    For information: MultiSubnetFailover enables faster failover for all Availability Groups and or Failover Cluster Instance in SQL Server and will significantly reduce failover time for single and multi-subnet Always On topologies.


    This is an enhancement request to support "Multi Subnet Failover"? fo Always On feature from MS SQL.