Ability to add additional connection parameters
In SQL Server management studio you have the ability to add additional connection parameters however there is no ability to be able to specify these in SQL Compare. This is a problem in SQL 2012 when trying to connect to availability group listeners that have replicas in multiple subnets. In order to connect to the availability group listener you need to specify the “MultiSubnetFailover=True” connection property, otherwise it results in a 50/50 chance of connecting successfully.
Benjamin Zamora commented
I am also having this same issue. Makes the tool useless in this situation
Peter Jelstrup commented
Being able to use Application Intent=ReadOnly and Encrypt=True would also be greatly appreciated.
Tony Price commented
Just add my vote - the tool can no longer be used as we cannot connect without MultiSubnetFailover=True
Mirek Svoboda commented
I know this post is already two years old, but appearing among top results on Google. I am hit by the same problem - I need to add “MultiSubnetFailover=True” connection property.
But I found nothing so far.
AlwaysOn is pretty mature and enterprise needed technology, I believe it must be supported. Maybe I just cannot find the right doc.
Please can you point me at the right direction?
Being able to add the Connection Timeout value would also be handy.