Remove SQL cluster node

sql-server sql-server-2012 windows-clustering
JBone picture JBone · Mar 31, 2014 · Viewed 14.8k times · Source

I am trying to remove a SQL 2012 cluster node from a Server 2012 R2 machine. However the windows and cluster itself has already been destoyed so when trying to remove the node the setup is erroring out in validation because ...

"The local computer is not a member of a Windows failover cluster"

and

"The SQL Server failover cluster service is not online, or the cluster cannot be accessed from one of it's nodes. To continue determine why the cluster is not online and rerun Setup. Do not rerun the rule because the rule cannot detect a cluster environment".

Does anyone know how to force the removal of a SQL clustered node?

Answer

Lager11B picture Lager11B · Jan 27, 2015

I know it's probably too late for you JBone, but I had the same issue and what I did was go into the registry and delete the ClusterName key for the instance. This lets the uninstall see this as a non-clustered instance and you can uninstall as a non-clustered instance through add/remove programs.

The registry key I removed was:

HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL11.MSSQLSERVER\Cluster:ClusterName

Related questions

How to check if a column exists in a SQL Server table?

I need to add a specific column if it does not exist. I have something like the following, but it always returns false: IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'myTableName' AND COLUMN_NAME = 'myColumnName') How can …

Read More
Auto increment primary key in SQL Server Management Studio 2012

How do I auto increment the primary key in a SQL Server database table, I've had a look through the forum but can't see how. I've looked the the properties but can't see an option, I have seen an answer …

Read More
Convert Date format into DD/MMM/YYYY format in SQL Server

I have a query in SQL, I have to get a date in a format of dd/mm/yy Example: 25/jun/2013. How can I convert it for SQL server?

Read More