Motivation: Making the Systems Engineers life easier.

Blog

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. Required fields are marked *

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