Multi Subnet Failover Support

Which version of Access Analyzer do you have?

Access Analyzer 12.0

What is a one sentence summary of your feature request?

Provide support for Multi Subnet Failover in storage connection profiles

Please describe your idea in detail. What is your problem, why do you feel this idea is the best solution, etc.

As an institution we have standardized on multi subnet failover. There’s no node for extra connection-string options. And when the server value contains =, ; or a space, the product wraps it in quotes. So MultiSubnetFailover=Yes typed into the server field becomes part of the Data Source value, which the driver rejects as an invalid connection string (error 87).

How do you currently solve the challenges you have by not having this feature?

Currently we have an intermittent delay that occurs in our connection since the round robin search has to timeout before looking for another connection. This causes performance delays.

1 Like