SQL 2012 AlwaysOn MultiSubnetFailover

Question

I have a three node SQL 2012 AlwaysOn Availability Group, with a Listener that I am trying to connect to with some of my .NET Applications. Two of the three nodes are in a different subnet. I have applied the "MultiSubnetFailover=true" connection string parameter, and the .NET 4.0.3 update has been applied on all of the client machines. Connectivity for some machines works fine, but others does not work at all.

I have been trying to figure out the differences between a client that can connect and one that cannot. I'm out of ideas and this point and asking for some help.

Any suggestions would be appreciated.

Kyle

Answer 1

It seems not like a data access problem

Did you get any error message when connection failed?