How to uninstall SQL-Server 2014 Instance

In this article you will find a perfect way to uninstall a stand-alone instance of SQL Server 2014.

Pre-requisites to uninstall an SQL Server instance:

  • You must login system as local administrator with permission to log on as a service.
  • You must have minimum amount of physical memory with enough page size. ( page size = 2 times of physical memory )

Important points to be consider before uninstall SQL Server 2014:

  • Backup your database.
  • Drop/Delete local security groups.
  • All SQL server services must be stop. This would leads to successful removal of SQL Server.

Note:

Manual action: We need to uninstall SQL Server Browser component, if you want to uninstall all components of SQL Server 2014.

To uninstall SQL Server instance, go to Control Panel and then Programs and Features.

How to uninstall SQL-Server 2014 - Control Panel

How to uninstall SQL-Server 2014 – Control Panel

 

Select and right-click on Microsoft SQL Server 2014 and select Uninstall/remove.

How to uninstall SQL-Server 2014 - Programs & Features

How to uninstall SQL-Server 2014 – Programs & Features

 

Click on remove.

How to uninstall SQL-Server 2014 - SQL Server 2014 - Remove

How to uninstall SQL-Server 2014 – SQL Server 2014 – Remove

 

How to uninstall SQL-Server 2014

How to uninstall SQL-Server 2014

 

Select instance & click next.

How to uninstall SQL-Server 2014 - Select Instance

How to uninstall SQL-Server 2014 – Select Instance

 

Select features you want to uninstall:

How to uninstall SQL-Server 2014 - Select Features

How to uninstall SQL-Server 2014 – Select Features

 

Verify Ready to remove wizard, click Remove.

How to uninstall SQL-Server 2014 - Ready to Remove

How to uninstall SQL-Server 2014 – Ready to Remove

 

Removal in Progress:

How to uninstall SQL-Server 2014 - Removal Progress

How to uninstall SQL-Server 2014 – Removal Progress

 

Congratulations, SQL Server 2014 is completely removed.

How to uninstall SQL-Server 2014 - Complete

How to uninstall SQL-Server 2014 – Complete

 

Reboot your system if possible.

By above method, we can uninstall SQL Server 2014.

************************************************************************

Note: Please don’t hesitate to revert in case of any query OR feedback.

Thanking you.

Have a easy life ahead.

6 thoughts on “How to uninstall SQL-Server 2014 Instance”

  1. Hi I have installed 2 instances on SQL server 2014, if I remove one instance by using the above un installation method. Will I be able to run other instance from the sql server or not ?

    • I request you to be more specific on your question, I found it bit confusing,
      Consider example, If you installed 2012 and 2014 SQL server (i.e. 2 instances) and you wanted to remove any one of them ( lets say 2012 SQL server) than it will be absolutely fine. Another instance (i.e. 2014)will work.

      And I request you to backup your database first before doing any kind of R & D.

      • Jignesh, Rishi question is , he installed 2 instance , default and named instance on sql server 2014 itself. so if he wants to uninstall the named instance by using above method. will he able to run other default instance ?
        so my answer is , Yes Rishi, no issues will happen but don’t un-installed the shared features while uninstall the named instance. Because shared feature are same for both the instance.

Leave a Reply