1

enter image description here

In Windows Server Failover Cluster Manager I can see "possible owners" under "Other Resource" and also under "Server Name".

I have a 3 node AlwaysOn Availability Group with 2 servers in synchronous mode and 1 in Asynchronous Mode for disaster recovery.

Under the possible owners under "Other Resource" I can see the ones in Synchronous mode is checked but under the 'Server Name' all are checked.

Will appreciate if any one can tell me the difference between possible owners listed under "Other Resource" versus those listed under "Server Name".

3

The names you're seeing under "Other Resources" are actually the SQL Server instance names, not the names of the nodes that could be possible owners.

"Possible Owners" are the machines that are eligible to run the Roles configured in the cluster. For SQL Server, Roles are the SQL Server instance, the SQL Server Agent service, etc.

"Other Resources" are items required to run each role.

The official Microsoft Docs on Failover Clustering with SQL Server is a great resource for understanding how that all ties together.

This MSDN blog talks about preferred and possible owners, and shows how SQL Server manages them automatically.

This Microsoft Docs page talks about the relationship between AlwaysOn and Failover Clustering. This section of the above page says:

Do not use the Failover Cluster Manager to manipulate availability groups, for example:

  • Do not add or remove resources in the clustered service (resource group) for the availability group.

  • Do not change any availability group properties, such as the possible owners and preferred owners. These properties are set automatically by the availability group.

  • Do not use the Failover Cluster Manager to move availability groups to different nodes or to fail over availability groups. The Failover Cluster Manager is not aware of the synchronization status of the availability replicas, and doing so can lead to extended downtime. You must use Transact-SQL or SQL Server Management Studio.

  • Thanks for the explanation. So for the Always on these are controlled automatically by the sql server, but for FCI in order to remove a node from possible owners do i need to remove it from both 'other resources' and 'Server name' – SQL_NoExpert Nov 1 '18 at 18:47
  • Mange Availability Groups via SQL Server Management Studio not Failover Cluster Manager. – Max Vernon Nov 1 '18 at 18:56
  • I understood the point but I also have a sql failover cluster for which i have to manage from failover cluster manager. During maintenance i have to remove nodes from possible owners and since the possible owner option is under both the 'other resources' and also the 'server name' was confused from where to remove that node.. – SQL_NoExpert Nov 1 '18 at 18:59
  • glutenfreesql.wordpress.com/2012/08/31/… may be the way to remove fro possible owner for Failover Cluster – SQL_NoExpert Nov 1 '18 at 19:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.