Monday 12 August 2013

SQL Server Database Services feature state rule failed while adding node to cluster - SQL 2008 R2

Error:
---------------------------
Rule Check Result
---------------------------
Rule "SQL Server Database Services feature state" failed.
The SQL Server Database Services feature failed when it was initially installed. The feature must be removed before the current scenario can proceed.

Fix:
Registry key needs to be modified on Active node.

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

Change all values from 2 to 1 for all four item and run the rule check again.

3 comments: