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

Asked By Jonathon Head 30 points N/A Posted on - 08/20/2012

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.

• Status: Open
• Question Views: 3808
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Misc Software

Best Answer by Carl Jack

Go To Solution

Best Answer

Best Answer

Answered By Carl Jack 10 points N/A #154145

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

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

About Carl Jack

Questions
1

Answers
1657

Best Answers
417

• Vote Up 0 Vote Down

• Posted on - 08/20/2012
• Question Category: Misc Software

Answered By cyrilsia01 1065 points N/A #154146

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

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.

About cyrilsia01

Questions
1

Answers
388

Best Answers
59

• Vote Up 0 Vote Down

• Posted on - 02/18/2013
• Question Category: Misc Software