I'm trying to understand something about Availability Group listeners that are configured on multiple subnets...
I have an availability group listener with two IP addresses on different subnets. Obviously, only 1 IP is online. If I do an nslookup against the listener name it comes back with both IP addresses as expected. If i ping the listener name, I will get a reply provided it resolves to the IP address that is currently online. If however, it resolves to the other IP address that is not online, it will not reply.
So, this leads me to understand that if I am connecting to an Availability Group via the listener name, and my client is not Multi-Subnet aware, there's a good chance that I will not be able to connect because the request may resolve to the wrong IP address. Is this correct?