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.