I need some help please.
I have a 2-node Windows cluster configured with WSFC (cluster name = ABCCluster). Node 1 named Node1 Node 2 named Node2
SQL 2019 instance installed and named INSTANCE Availability Group configured and named INSTANCE_AG Availability Group listener prestaged and named AGL_INSTANCE
In Failover Cluster Manager, Cluster Events, I get following error:
Cluster network name resource failed registration of one or more associated DNS names(s) because the access to update the secure DNS Zone was denied. Cluster Network name: 'INSTANCE_AG_AGL_INSTANCE' DNS Zone: 'our.domain.com' Ensure that cluster name object (CNO) is granted permission to the Secure DNS Zone
Question 1: Where has that strange Cluster name come from i.e. 'INSTANCE_AG_AGL_INSTANCE'? The cluster name in Failover Cluster Manager is ABCCluster
Question 2: The prestaged listener name has been attached to that strange cluster name, has prestaging the listener got anything to do with this error message?
Question 3: As it is now, automatic failover for the AG happened from Node1 replica to Node2 replica when I stopped the SQL service on Node1 (which was previously the primary replica in the AG). However, when I stop the service on Node2, it doesn't failover automatically back to Node1. Node1 rather stays in 'RESOLVING' state for some time until the SQL service is started back on Node2 and then the Node1 replica resolves as 'secondary'. So, I have only a one-directional automatic failover.
I would appreciate any ideas on what I'm doing wrong please.