SQL Server 2012 Cluster Install Error : "SQL Server Database Services feature state"

Leave a comment (0) Go to comments

"SQL Server Database Services feature state". This was the Error Message, which I received this morning during building / Installing a SQL Server 2012 cluster.

SQL Server 2012 Cluster Install Error : "SQL Server Database Services feature state" SQL Error sql cluster install error

FIX / Resolution / Workaround :

Change registry key on active node:

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11.SQLDEV2012\ConfigurationState]

Change all entry values from 2 to 1

Incident happened to me in Detail

I had  some issues in installing SQL Server 2012 in first node in a two node cluster, where a SETUP has ended up with error but I manually resolved those issues and my SQL Services worked fine of NODE 1 of SQL Server Cluster.

This morning when I was adding a another node in the same cluster, I ended up getting error "SQL Server Database Services feature state". This error basically means, the previous installation of SQL Server didn’t completed with successful status, which was correct in my case.


But I corrected these issues, why SQL Server Installation is unable to check the current status /why is checking previous status.

The answer is, During SQL Server Node installation, Set up check installation status from Active NODE and that information is read out from Registry entry. This registry setting is located at

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11.SQLDEV2012\ConfigurationState]

SQL Server 2012 Cluster Install Error : "SQL Server Database Services feature state" SQL Error sql cluster install error

Change all values from 2 to 1 where 2 means Failed and 1 means success. SO I am explicitly telling setup that my previous installation was  Successful.

After this Re-RUN the test and it should be completed successfully this time.

SQL Server 2012 Cluster Install Error : "SQL Server Database Services feature state" SQL Error sql cluster install error

Summary: There is no need to reinstall the SQL server on NODE 1 to fix Cluster Installation RULE Error "SQL Server Database Services feature state" . Just modify the registry value to fix this issue.

EOF - SQL Server 2012 Cluster Install Error : "SQL Server Database Services feature state", SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.