ERROR:The sql server database services feature failed when it was initially intalled.the feature must be removed before the current scenarion can proceed

Today when I am Adding node to sql server 2012 cluster I got one of the

Error :

The sql server database services feature failed when it was initially installed.the feature must be removed before the current scenario can proceed

For the above error says:there was problem on the installation which we have done already on first node so when we are trying to add node to specific cluster it through this kind of errors.

Resolution:

when the installation of sql server is success we can see the values on the registry  will be always '1'on the location:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.\ConfigurationState

when the installation having some problem the value in registry will be '2' you can see in the screen shot below.

So this is why our add node installation is getting failed.

when we are installing on the first node all the installation went cool but at the end our DQS was failed.you can see the error from the below screenshot

To resolve the issue with DQS ,we have manually ran the DQSIntaller.exe on the cluster now the DQS is running fine but it not updated in the registry.

That is why I got this error why I am running add not the cluster it is getting failed so to bi-pass this error I have made a change in the registry file

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.\ConfigurationState

SQL_DQ_FULL DWORD 0x00001(1)

Finally I have added node to cluster successfully.

(OR) you can run the repair from media setup file you can fix the problem like this and then you can add node to cluster as well.

Note:Before change any registry setting take the backup of the registry