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

F Ahmed 36 Reputation points
2022-04-05T20:14:40.57+00:00

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,105 questions
Windows Server Clustering
Windows Server Clustering
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Clustering: The grouping of multiple servers in a way that allows them to appear to be a single unit to client computers on a network. Clustering is a means of increasing network capacity, providing live backup in case one of the servers fails, and improving data security.
969 questions
{count} votes

1 answer

Sort by: Most helpful
  1. CathyJi-MSFT 21,111 Reputation points Microsoft Vendor
    2022-04-06T03:35:33.967+00:00

    Hi @F Ahmed ,

    >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".

    1 person found this answer helpful.
    0 comments No comments