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.
Anonymous
shared this idea
-
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? -
Ray
commented
Being able to add the Connection Timeout value would also be handy.