While deploying SQL Server 2016 cluster in my lab I ran into this problem when I was trying to add a second node to the SQL cluster. Let us learn about Add Node Error and how to solve it in this blog post.
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.
I searched on the internet and found that this is due to the registry key
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL13.MSSQLSERVER\ConfigurationState
The value you would see in 4 and that needs to be changed to 1 for setup to move forward.
But is that really the solution? I was thinking that there must be a reason why the value was set to 4.
As per one of Microsoft forums answer by a Microsoft Employee – “This error means the initial first node installation failed and AddNode is now blocked. You should go to the first node and check setup log files to see if the installation succeeded or failed. If the first node failed, then you would need to uninstall it and try the installation again. Then you should be able to add addition nodes.”
The above makes more sense because if there was some error in first node install, then we need to fix that first rather than changing a registry key. If I get this error, I would do below.
- Investigate cause of failure on the first node.
- Fix that cause and repair the instance.
- Then check the key whether it changed to 1 automatically.
- Else uninstall and install first node instance.
One of the forum post said this this was due to incomplete deployment of SQL Server and SQL Agent resource in the cluster. Here are few of my earlier articles which can also have a similar issue.
Have you received a similar error? What was the fix for you?
Reference: Pinal Dave (https://blog.sqlauthority.com)