Un-Install a SQL Server Cluster: Step-by-Step

If SQL Server Cluster Install ends up in errors and fails, consider doing a clean up of the cluster install and then re-start it.

Here is a step-by-step process which gives a clean un-install of a SQL Server Cluster environment.

Step-1 Execute sqlrem.bat

Execute sqlrem.bat with following parameters on each node:

Syntax:

sqlrem.bat <sql install path> <instance name>

Sample:

sqlrem.bat D:MSSQLMSSQL$ONESQL ONESQLONESQL_1

Step-2 Remove Alias Remove alias with clicnfg.exe on each node.

Step-3 Un-Install Microsoft Data Access Components

Un-install Microsoft Data Access Components from each node. This can be done using Add Remove Programs in Control panel.

Step-4 Erase Physical Directory Structure

Remove physical directory structure from each node

1. SQL Server Binary files Program filesMicrosoft SQL Server

2. Data files folder MSSQLMSSQL

Step-5 Remove Resources with Cluster Admin

Remove the following SQL Server resources registered with Cluster Administrator.

1. SQL IP Address

2. SQL Network Name

3. SQL Server

4. SQL Server Agent

Step-6 Registry Clean Up Remove following registry keys if they are found: Cluster Related:

1. HKEY_LOCAL_MACHINEClusterResourceTypesSQL Server
2. HKEY_LOCAL_MACHINEClusterResourceTypesSQL Server Agent

SQL Server Software Related:

1. HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server

MSSQL Instance Related:

1. HKEY_LOCAL_MACHINESOFTWAREMicrosoftContentIndexCommonLanguageResources
OverrideSQLServer$ONESQL_1
2. HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindows NTCurrentVersionPerflib09
3. HKEY_LOCAL_MACHINESYSTEMControlSet001EnumRootLEGACY_MSSQL$ONESQL_1
4. HKEY_LOCAL_MACHINESYSTEMControlSet002EnumRootLEGACY_MSSQL$ONESQL_1
5. HKEY_LOCAL_MACHINESYSTEMCurrentControlSetEnumRootLEGACY_MSSQL$ONESQL_1
6. HKEY_LOCAL_MACHINESYSTEMControlSet001ServicesMSSQL$ONESQL_1
7. HKEY_LOCAL_MACHINESYSTEMControlSet001ServicesMSSQLServerADHelper
8. HKEY_LOCAL_MACHINESYSTEMControlSet001ServicesSQLAgent$ONESQL_1

Step-7 Erase the Shortcuts 1. Remove the SQL Server shortcuts in Startup menu as well as desktop.
2. Remove the Service manager entry located in startup menu.
3. Remove the Programs Microsoft SQL Server folder

Step-8 Restart the Cluster

Restart the Cluster Nodes one by one.