none
Cluster service verification failes when trying to install SQL Failover Cluster Instance on a new node

    Question

  • We have three node SQL cluster to which we added the fourth node. I've run cluster validation, without Network and Storage validation because I can not get a downtime for full validation. Beside warnings about quorum configuration and resources not having all the nodes of the cluster listed as Possible Owners, everything else successfully passes the validation.

    Then, when I try to install SQL Failover Cluster Instance with Add Node option on a new node which has been added to the cluster I get failed rule status for Cluster service verification and Microsoft Cluster Service (MSCS) cluster verification errors at the Setup Support Rules step. 

    When checking Details.txt log file under C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\ there are fallowing errors logged regarding these two rules; 

    (10) 2017-02-14 08:40:35 Slp: Initializing rule      : Cluster service verification
    (10) 2017-02-14 08:40:35 Slp: Rule is will be executed  : True
    (10) 2017-02-14 08:40:35 Slp: Init rule target object: Microsoft.SqlServer.Configuration.Cluster.Rules.ClusterServiceFacet
    (10) 2017-02-14 08:40:35 Slp: Rule 'Cluster_IsOnline' detection result: Is Cluster Online Results = False; Is Cluster Verfication complete = False; Verfication Has Warnings = True; Verification Has Errors = True; on Machine SERVERCSQL04
    (10) 2017-02-14 08:40:35 Slp: Evaluating rule        : Cluster_IsOnline
    (10) 2017-02-14 08:40:35 Slp: Rule running on machine: SERVERCSQL04
    (10) 2017-02-14 08:40:35 Slp: Rule evaluation done   : Failed
    (10) 2017-02-14 08:40:35 Slp: Rule evaluation message: The SQL Server failover cluster services is not online, or the cluster cannot be accessed from one of its nodes. To continue, determine why the cluster is not online and rerun Setup. Do not rerun the rule because the rule cannot detect a cluster environment.
    (10) 2017-02-14 08:40:35 Slp: Send result to channel : RulesEngineNotificationChannel

    (10) 2017-02-14 08:40:36 Slp: Initializing rule      : Microsoft Cluster Service (MSCS) cluster verification errors
    (10) 2017-02-14 08:40:36 Slp: Rule is will be executed  : True
    (10) 2017-02-14 08:40:36 Slp: Init rule target object: Microsoft.SqlServer.Configuration.Cluster.Rules.ClusterServiceFacet
    (10) 2017-02-14 08:40:36 Slp: Rule 'Cluster_VerifyForErrors' detection result: Is Cluster Online Results = False; Is Cluster Verfication complete = False; Verfication Has Warnings = True; Verification Has Errors = True; on Machine SERVERCSQL04
    (10) 2017-02-14 08:40:36 Slp: Evaluating rule        : Cluster_VerifyForErrors
    (10) 2017-02-14 08:40:36 Slp: Rule running on machine: SERVERCSQL04
    (10) 2017-02-14 08:40:36 Slp: Rule evaluation done   : Failed
    (10) 2017-02-14 08:40:36 Slp: Rule evaluation message: The cluster either has not been verified or there are errors or failures in the verification report. Refer to KB953748 or SQL Server Books Online for more information.
    (10) 2017-02-14 08:40:36 Slp: Send result to channel : RulesEngineNotificationChannel

    Failed status for Microsoft Cluster Service (MSCS) cluster verification errors is present because Cluster Network and Cluster Storage were not validated. I can skip this rule check with /skiprules=Cluster_VerifyForErrors (I know it is not recomended) to install Cluster SQL Instance.

    But, what I do not know is why the Cluster service verification rule fails. Something's not right and I think that is a red light, but I do not know what is the cause for it. Any suggestions?

    Tuesday, February 14, 2017 8:05 AM

Answers

  • Solved! Cluster node has been in Paused state.

    Fallowing technet article describes Pausing and Resuming nodes;

    https://technet.microsoft.com/en-us/library/cc731291(v=ws.11).aspx

     
    • Marked as answer by dejc Tuesday, February 14, 2017 12:34 PM
    • Edited by dejc Tuesday, February 14, 2017 12:37 PM
    Tuesday, February 14, 2017 12:34 PM

All replies

  • Solved! Cluster node has been in Paused state.

    Fallowing technet article describes Pausing and Resuming nodes;

    https://technet.microsoft.com/en-us/library/cc731291(v=ws.11).aspx

     
    • Marked as answer by dejc Tuesday, February 14, 2017 12:34 PM
    • Edited by dejc Tuesday, February 14, 2017 12:37 PM
    Tuesday, February 14, 2017 12:34 PM
  • Glad this is working. Don't worry about running full validations. They will not interfere with the existing cluster.
    Tuesday, February 14, 2017 12:52 PM
  • Thanks! I've totaly forgot to check if node is in Paused state! 

    Cluster validation performs disk failover test. I believe that existing SQL instance will go offline when disk failover test would occured. Right?


    Tuesday, February 14, 2017 1:03 PM
  • There are parts you want to avoid. These are all in the storage category and IIRC are Validating Disk Arbitration, Disk Failover, Multiple Arbitration, SCSI-3 Persistent Reservation, and Simultaneous Failover.
    Tuesday, February 14, 2017 1:35 PM