Friday, February 5, 2016

cluster service verification failed while installation of sql 2008 R2 on Windows 2012 Cluster




While performing SQL Server 2008 R2 installation on Windows 2012 Server then we may got the below error showing Cluster Service verification failed because 2008R2 is not originally designed for 2012 OS.







Solution:


Install Cluster Automation Server (add-windowsfeature RSAT-Clustering-Automation Server)


Below are the steps:


C:\ Get-WindowsFeature RSAT-Cluster*          -- Displays list of features that are installed


Display Name                                            Name                       Install State
------------                                            ----                       -------------
        [X] Failover Clustering Tools                   RSAT-Clustering                Installed
            [X] Failover Cluster Management Tools       RSAT-Clustering-Mgmt           Installed
            [X] Failover Cluster Module for Windows ... RSAT-Clustering-Powe...        Installed
            [ ] Failover Cluster Automation Server      RSAT-Clustering-Auto...        Available
            [ ] Failover Cluster Command Interface      RSAT-Clustering-CmdI...        Available


C:\Install-WindowsFeature -Name RSAT-Clustering-AutomationServer


After successful installation of Cluster Automation Server, close all your applications and restart SQL Server 2008 R2 cluster installation.