We are starting to deploy Multi-Subnet HADR AlwaysOn clusters for our environment. Using MultiSubnetFailover=True in application connection strings works.
However, SSMS connections require manual paste of this connection parameter into the additional connection parameters window for every connection.
Is there a workaround to automatically add this for all connections?
Alternately, using a Central Management Server to store connections for multiple SQL Servers, is there a way to store this here?
Thanks. Jeremy
