Is there any way to 'de-cluster' an instance of SQL Server 2012 that was installed using the 'New SQL Server Cluster Installation' option? We are having issues with the failover portion of clustering services and since we did not implement the cluster (and really there is no need) we would like to turn this into a stand-alone installation. Removing the Windows Clustering portion just took SQL down with it. All help and insight is appreciated, thanks!
Sql-server – De-Cluster SQL Server 2012
clusteringsql serversql-server-2012
Best Answer
You need to do this through the installer. Choose remove node from cluster in the SQL Server installer.
http://msdn.microsoft.com/en-us/library/ms191545.aspx