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.
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:
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
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.
