Hi Team,
Need urgent help!
We have sql server 2017 always on windows failover cluster. It has 4 nodes, 2 nodes from DC1 (Node1 is primary) and 2 nodes from DC2. Created a listener with multisubnet ip addresses.
The problem is when clients trying to connect listener, it it connecting to multiple addresses. sometimes connecting online IP address sometimes connecting to offline IP address.
How to resolve connectivity issues with SQL Server 2017 Availability Groups.
Thanks in Advance!
If your using RegisterAllIPProviders = True on the cluster side your connection strings must use Multisubnetfailover=True option so it will try all IP addresses and route to the correct one.
If your connection drivers cannot understand the multisubnetfailover connection string attribute you must set RegisterAllIPProviders to False then you are at the mercy of DNS to update when you failover to DR for apps to re-establish connections.
15 People are following this question.
