I have 3 node SQL server 2014 SP3-CU4-GDR, and each server is on a different subnet:
and I have the listener with mutliple subnets configured like so:
192.168.1.0/24 - ip address 192.168.1.26
192.168.2.0/24 - ip address 192.168.2.26
192.168.3.0/24 - ip address 192.168.3.26
192.168.4.0/24 - ip address 192.168.4.26
so the problem is, server 1, when i ping the listener name (its just called ServerListener... just an example), and it does ping the ip address: 192.168.1.26... however server 2 and 3 go to either 192.168.2.26 or 192.168.3.26... but i need them to go to 192.168.1.26 when pinging the listener... where can i configure that to point to correct IP addresses?
I tried already fail over several times to each node, which now if I fail to server 2, I am able to ping 192.168.2.26, but then when i try and ping again, it tries to ping 192.168.3.26, so I am not sure where or what or how to register the servers to make them away of the other ip addresses to point to the listener name listener?