A closer look at everything related to SQL Server

Here I am putting down a simple method of removing SQL Server 2016 named or default instance. I am assuming here that there are no user databases on this instance. I stopped all SQL  Server services before I started this uninstall process.

  1. To begin the uninstall process, go to Control Panel and then Programs and Features.
  2. Select Microsoft SQL Server 2016 and select Uninstall. Then click Remove. This starts the Remove SQL Server 2016 Wizard.

                                                              

  1. Setup Support Rules runs to verify your computer configuration. Since there is only one instance of SQL server 2016 on this machine, wizard selects it for you. Otherwise, you can use the drop-down menu to select your instance for removal. To continue, click Next.

4. After hitting NEXT, you will get Ready to Remove dialog box showing the summary of Engine and features that are going to be removed. Click Remove. The removal process will begin and it may take several minutes depending on your installation.

  1. If everything goes smoothly, you will receive a success message. You can go to the hyperlinked text file to see the report of the whole process of removal. Click Close to complete the removal of SQL Server 2016 instance.

In the end, you can refer to this TechNet document for more detailed instructions. https://technet.microsoft.com/en-us/windows/ms143412(v=sql.90)

 

Advertisements

Comments on: "Steps to remove SQL Server 2016 Instance" (5)

  1. I just installed SSE, botched the install, and wanted to go back and fix it. Except for your post here I haven’t found a single note via Googling about how to remove an individual instance. There are references to Remove Programs but I skipped those pages, thinking “I don’t want to remove the whole SS installation!” But your page clarifies that with Remove we get the option to remove a single instance rather than the entire product. YAY. THANKS!

  2. Should it remove full sql server 2016 or only just Instance?

    • Keny,
      It depends. If you have other instances installed maybe there are sharing other SQL Server components such as client connectivity etc. In this case only remove the instance of SQL Server you are interested in. But if this is the only instance and you want to start fresh, remove all other components as well.

  3. jasona22 said:

    This does not remove sql server completely. SQL install leaves all kinds of junk behind including all the folders in program files, odbc and other junk. There is nothing easy about removing sql server.

Leave a Reply to jasona22 Cancel reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: