question

FAhmed-4761 avatar image
0 Votes"
FAhmed-4761 asked Cathyji-msft edited

Cluster wouldn't update the IP after failover unless you restart the cluster services.

I have 3- node ( SQLNODE1,SQLNODE2,SQLNODE3) AAG setup over 2 different subnets. To my knowledge I have given all the necessary permissions to in AD to all resources, node names , listener name. When I failover to another subnet, listener ( SQLAGListner) fails over and I see the IP being updated in cluster manager, however cluster ( SQLAGCLuster) doesn't update the ip unless I restart the cluster. I have been scratching my head for days on this, what could I be missing? I have this set up in my lab and willing to try any option.

My hope is when AG failsover to another subnet, cluster should also follow along.

sql-server-generalwindows-server-clustering
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @FAhmed-4761,

Any update for this thread? Did the reply could help you? If the response helped, do "Accept Answer". If it is not, please let us know.

0 Votes 0 ·

1 Answer

Cathyji-msft avatar image
1 Vote"
Cathyji-msft answered

Hi @FAhmed-4761,

however cluster ( SQLAGCLuster) doesn't update the ip unless I restart the cluster.

SQLAG cluster IP? Did you mean SQL AG listener IP, could you describe this issue more clearly or share us a screenshot to better understand this issue?

IP address for SQL server AG listener changed to another subnet IP when you failover the AG to another subnet. You need to assign two different virtual IPs (one from each subnet) to your AG listener. When the Availability Group Listener (AGL) is configured properly, it will have an IP address for each defined subnet and have an “OR” dependency on each of the IP addresses.

Please check your steps follow below blog to find if you missed something.

Configure SQL Server AlwaysOn Availability Group on a Multi-Subnet Cluster


If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.