SQL Server Database Services Feature State Failed on building SQL 2012 Cluster

Asked By 30 points N/A Posted on -
qa-featured

During building SQL Server 2012 cluster I have got the following error message. I have no idea why this is happening?

I need help. Please post comment if you have any information regarding this.

The SQL Server database Services feature failed when it was initially installed. The feature must be removed before the current scenario can proceed.

SHARE
Best Answer by Carl Jack
Best Answer
Best Answer
Answered By 0 points N/A #154145

SQL Server Database Services Feature State Failed on building SQL 2012 Cluster

qa-featured

Hello Jonathan,

The error that you are getting implies that the first node installation did not go well, and the addnode is blocked. What you will need to do to resolve it is the following:

  • Go to the first node and then check the setup log files to verify if the installation was successful or it failed.
  • In case the first node did not succeed, you will have to uninstall it and then retry the installation. That will enable you to add more nodes.

Otherwise you can try changing this reg key and see if that also can help resolve the issue. Make sure that  you change registry key on active node:

HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerMSSQL10.BENEDICTConfigurationState
Change all 4 values from 2 to 1

After that download and extract the service pack by running the following command: 

SQLServer2008SP2-KB979450-x64-ENU.exe /x:C:SP2

Run: C:SP2x64setup1033sqlsupport.msi

Run from source media:
Setup.exe /PCUSource=C:SP2 /SkipRules=Cluster_IsDomainController Cluster_VerifyForErrors /Action=AddNode

Regards,

Carl

Answered By 985 points N/A #154146

SQL Server Database Services Feature State Failed on building SQL 2012 Cluster

qa-featured

The initial first node installation was failed here so to fix this, you need to run the repair feature on SQL server. You can found it under the Maintenance Page in SQL set up. This will fix the error on your installation. But if still not fixed, you need to go to your system registry locate this:

HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerMSSQL10.BENEDICTConfigurationState

You need to change all values there from 2 to 1. Change that then run again the set up. Should be fix. If you can upgrade your SQL server, then do it for more features and less error. Good luck.

Login/Register to Answer

Related Questions