hdctest (4/2/2015)
Hello,I have a SQL cluster and the Witness disk status shows as online but the passive node shows a "cluster event" that the passive node failed to form a cluster due to this witness issue. Oddly, the failover manager from the active node does not show this or any cluster event. the SQL cluster has not failed over recently.
Can you tell me how to correct the passive node's witness issue? I'm not sure where to even begin.
Need a bit more info really.
how many nodes in the cluster?
how many clustered instances of sql server?
If you don't have a great deal of experience I'd get someone to look at it who does have the relevant knowledge. Have you consulted with your windows server engineer?
If you can post the output of the following Powershell queries it would be helpful
import-module failoverclusters
get-clusterquorum
import-module failoverclusters
get-clustergroup | ft name, iscoregroup, ownernode, state
import-module failoverclusters
get-clusterresource | ?{$_.iscoreresource -EQ "True"} | ft name, iscoreresource, ownernode, ownergroup
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉