question

ShivkumarMallesappa-3997 avatar image
0 Votes"
ShivkumarMallesappa-3997 asked LimitlessTechnology-2700 answered

Troubleshooting Three Node WSFC Cluster

I am trying to build a three node WSFC Cluster, I will be implementing SQL Always On Failover Cluster Instances into this Cluster once it is successfully configured.
I am totally new to this Windows WSFC technology.
I have performed the following steps in my AWS account to Setup the Cluster.

  • Created Managed AD

  • Launched 3 Windows SQL Server Instances with AD Configuration (2 Instances are launched in one AZ and 1 Instance is launched in another)

  • Added the Instances to AD using SSM

  • Added secondary IP to the instances

  • Installed FCI Features using Server Manager on all of the three nodes

  • Checked Validation Configuration

  • Created Cluster

My Queries:

  • In my Cluster Summary I am able to see only two nodes under Cluster Core Resources. I was excepting three nodes. Is this my understanding correct?

  • The overall Cluster status is online, but when I try to bring one of the other Node online, it gives me error
    "Error Code: 0x80071397" The operation failed because either the specified cluster node is not the owner of the group, or the node is not a possible owner of the group." What does this mean?

  • On my Three Nodes I can see the error: Cluster resource 'Cluster Name' of type 'Network Name' in clustered role 'Cluster Group' failed. Based on the failure policies for the resource and role, the cluster service may try to bring the resource online on this node or move the group to another node of the cluster and then restart it. Check the resource and group state using Failover Cluster Manager or the Get-ClusterResource Windows PowerShell cmdlet. What does this mean and how to resolve it? This is something which I am not able to understand.

  • I am also getting the following warning : No matching network interface found for resource 'Cluster IP Address' IP address '10.85.239.XXX' (return code was '5035'). If your cluster nodes span different subnets, this may be normal. Will this impact my Cluster?

  • Will I need Quorum and Witness configurations in this setup? I will be using AWS FSx as a shared storage for this Cluster, so I am bit confused about Witness/Quorum/File Share Witness etc. It will be great if someone could also throw some light on this as well.

  • Overall my setup is correct or there is something which I misconfigured or missed?

Please refer to the attached screenshots for the overall infra setup:

Overview
Node Details
Warning
Error
Node Bring Up Error


windows-serverwindows-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 ShivkumarMallesappa-3997,
Your questions are related to windows failover clustering. It is better to add tag Windows-Server-Clustering so that experts there will help you more efficiently. If you have any questions about SQL Server getting started, SQL Server Database, SQL Server Mirror and replication and SQL Server High Availability and Disaster Recovery, you can open a thread in the tag sql-server-general.

Best Regards,
Amelia

0 Votes 0 ·

1 Answer

LimitlessTechnology-2700 avatar image
0 Votes"
LimitlessTechnology-2700 answered

Hello @ShivkumarMallesappa-3997,

Thank you for your question.

After manually bringing down a cluster or after a cluster fails, a group and all of its resources can fail if the cluster experiences a loss of a node. However, the group can also go into an offline state.

Access the article below to see possible scenarios of this happening and how to resolve it:

https://docs.microsoft.com/en-us/troubleshoot/windows-server/high-availability/error-messages-bring-cluster-group-online



If the answer is helpful, please vote positively and accept as an answer.

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.