September 13, 2021 at 6:24 pm
Hello,
I have 3 node SQL server 2014 SP3-CU4-GDR, and each server is on a different subnet:
server1: 192.168.1.25
server2: 192.168.2.25
server3: 192.168.3.25
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?
September 13, 2021 at 7:19 pm
if you do an nslookup to the listener do you get all the IPs back?
if so you need to either disable registeraipproviders
or the recommended approach, change your applications to use the multisubnetfailover=true connection string attribute.
September 13, 2021 at 7:28 pm
Hey Ant-Green,
thank you for your reply,
so very very weird... on Server 2 and 3, when i do the NSlookup, the ip addresses in order are never consistant.. example
first time i do nslookup on server 2 or 3:
it would say address:
192.168.2.26
192.168.3.26
192.168.1.26
then the second time it would change the order:
192.168.3.26
192.168.2.26
192.168.1.26
what i need it to do is point to 192.168.1.26 then the others second, as right now 192.168.1.26 is the pingable working, also, I am trying to point my SSRS server to the Always On listener, so not sure if it has that option: multisubnetfailover=true or maybe it does?
September 13, 2021 at 7:39 pm
Yeah you will get results in varying order depending which dns server responds to the query.
SSRS does support multisubnetfailover=true in the connection string.
that is the official stance from Microsoft, if you have multiple IPs use the right connection string attributes.
if the driver doesn’t support the options then you need to switch off the option and then your at the mercy of dns replication and having downtime each time the replica fail over. And we all know all problems point to DNs right so best to not mess with that and use MSF=True option.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply