Motivation: Making the Systems Engineers life easier.

Remove an instance from the SQL Failover Cluster

Microsoft SQL

Remove an instance from the SQL Failover Cluster

I have a two (2) node SQL Failover Cluster, and I had install an instance in my one of the SQL Failover Cluster node. For some reason I had to uninstall this instance but when I tried uninstalling through: Control Panel –> Program and Features —> Right click on Microsoft SQL Server 2012 (64 bit) and click remove, and it failed because when you try to remove it from Control Panel you get the following error:

In order to remove the SQL Failover Cluster Instance successfully use the following steps:

 

  1. Double click on the SQL Server “Setup.exe”.

2.  Click on “Maintenance” in “SQL Server Installation Center”

3. Click on “Remove node from a SQL Server failover cluster” in “SQL Server Installation Center”

4. Click on “OK” in “SQL Server 2012 Setup”

5. Click on “Next” in “Remove a Failover Cluster Node”

6. Select the instance name you want to remove.

7. click on “Next” in “Remove a Failover Cluster Node”

8. Click on “Remove” in “Remove a Failover Cluster Node”

9. Click on “Close” in “Remove a Failover Cluster Node”.

Now the instance is removed successfully.

Leave your thought here

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Topics