Cluster service verification Failed error
January 7, 2013 13 Comments
While installing SQL 2008 R2 database server on a failover cluster, the Setup Support Rules identifies problem that might occur when you install SQL Server Setup support files. Any failures must be corrected before setup can continue.
The following rules may fail when you install SQL 2008 R2 database server on a Windows 2012 failover cluster.
Cluster service verification…. Failed
Microsoft Cluster Service (MSCS) cluster verification errors…. Failed
How to fix this?
Install Failover Cluster automation Server feature on all the cluster nodes and rerun the SQL database setup wizard.
To install Failover Cluster automation Server feature, Open Server Manager and then click on Manage and select Add Roles and Features.
Follow the wizard and from Features page, drill down Remote Server Administration Tools – Feature Administration Tools – Failover Clustering Tools and select Failover Cluster automation Server.
Hope this bit of information is helpful for someone to resolve their problem.
This is exactly what I was suffering from on a recent VMWare/Windows 2012 Server/MS Cluster/SQL 2008 R2 deployment and you’ve given me the answer which solved my problems!
Thanks so much Jay.
Hey guy, good tip.
This was the only tip that realy solved this issue.
Helped much.
Thank you very much.
You Rock , thank you very much ! I had Failover Cluster Automation Server installed on one node and not on the other one (for some unknown reason) and it would not pass the SQL test eventhough the Windows Cluster Verification test passed without any problem . Very frustrating to troubleshoot because the Windows Failover Cluster is working fine. I spent a lot of time trying the other proposed solutions out there like using procmon to identify the xml file etc.
Exactly what I was missing. Thank you!
Yepp, this helped me too.
thank you soooooo much man…… 🙂
I was working two days to find this issue and search every whare. This solve my problem. You are my God. Thank you very much
Awesome! Thanks a lot! Exactly what I needed…
Wow. I’m glad I found this after 30 mins… two days is not in my cluster ramp-up timeframe. Thank you very much!
Hi ! I am facing the same issue on Window 2008 server and Sql Server 2008R2 .We are trying to search ,Administration Tools – Failover Clustering Tools and select Failover Cluster automation Server.But did not find. Could you please help me to solve it ?
Failover Cluster automation server feature is available in Windows server 2012.
For server 2008 R2, Run the cluster validation one more time for windows cluster. If it gives all successful, then you can skip the cluster validation during SQL setup. You may follow the command line installation to skip the cluster validation at SQL setup.
Setup /SkipRules=Cluster_VerifyForErrors /Action=InstallFailoverCluster
Setup /SkipRules=Cluster_VerifyForErrors /Action=CompleteFailoverCluster
Setup /SkipRules=Cluster_VerifyForErrors /Action=AddNode
Reference link:
http://support.microsoft.com/kb/953748?wa=wsignin1.0
recently i was resolved this kind of issue , while installing SQL 2008 cluster on Windows 2012 i go this Cluster service failed error.
You can fix this issue by running this Command on poweshell
(add-windowsfeature RSAT-Clustering-AutomationServer)
it helped me resolve this specific error