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!