SQL Server Failover Clustering and HA Help!

%3CLINGO-SUB%20id%3D%22lingo-sub-2140266%22%20slang%3D%22en-US%22%3ESQL%20Server%20Failover%20Clustering%20and%20HA%20Help!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2140266%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%20I%20desperately%20need%20help!%20I%20am%20working%20on%20a%202-node%20failover%20cluster%20of%20a%20sql%20server%20That's%20also%20configured%20is%20HA.%20One%20of%20the%20nodes%20has%20been%20down%20and%20offline%20for%20months....%20This%20node%20cannot%20be%20brought%20back%20online.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20cluster%20was%20originally%20configured%20to%20use%20a%20file%20share%20witness.%20The%20file%20share%20went%20offline%20and%20cannot%20be%20brought%20back%20online.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20noticed%20that%20the%20cluster%20was%20down%20on%20the%20sole%20remaining%20node.%20I%20had%20to%20force-start%20the%20cluster%20and%20it%20successfully%20came%20online.%20I%20successfully%20reconfigured%20the%20quorum%20to%20use%20an%20Azure%20Cloud%20Witness%20for%20the%20cluster.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhile%20the%20cluster%20is%20online%2C%20the%204%20roles%20-%20pertaining%20to%20the%204%20Availability%20Groups%20are%20in%20a%20%22failed%20state.%22%20Any%20attempts%20to%20bring%20online%20fail.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20not%20able%20to%20login%20to%20any%20sql%20instance%20on%20this%20node%20as%20a%20result%20is%20SSMS.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20getting%20the%20following%20event%20ids%20in%20the%20logs%3A%201069%2C%201205%2C%20%26amp%3B%201254.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20hope%20for%20this%3F%20Information%20I've%20binged%20point%20to%20the%20cluster%20starting%20in%20a%20%22force%20quorum%22%20state%20-%20though%20that%20is%20not%20clear%20from%20what%20I%20see.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20node%20that%20was%20powered%20off%20and%20cannot%20be%20powered%20back%20on%20has%20been%20evicted%20from%20the%20cluster.%20Yet%2C%20no%20luck.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHelp!!!!%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi! I desperately need help! I am working on a 2-node failover cluster of a sql server That's also configured is HA. One of the nodes has been down and offline for months.... This node cannot be brought back online.

 

This cluster was originally configured to use a file share witness. The file share went offline and cannot be brought back online.

 

I noticed that the cluster was down on the sole remaining node. I had to force-start the cluster and it successfully came online. I successfully reconfigured the quorum to use an Azure Cloud Witness for the cluster.

 

While the cluster is online, the 4 roles - pertaining to the 4 Availability Groups are in a "failed state." Any attempts to bring online fail. 

 

I am not able to login to any sql instance on this node as a result is SSMS.

 

I am getting the following event ids in the logs: 1069, 1205, & 1254.

 

Is there any hope for this? Information I've binged point to the cluster starting in a "force quorum" state - though that is not clear from what I see. 

 

The node that was powered off and cannot be powered back on has been evicted from the cluster. Yet, no luck.

 

Help!!!! Thanks!

0 Replies