QuickQuestion: How to uninstall a SQL Server feature?

Uninstall a SQL Server feature - header

QuickQuestion series is a series of short posts in which I answer database related questions asked by my colleagues, friends, and co-workers, mainly application developers.

Today’s question:

How to uninstall a SQL Server feature?

If you wonder if it is possible to uninstall particular SQL Server feature instead of uninstalling the complete instance, then I have a good news. It is possible and it is very easy.

Let’s assume you want to uninstall PolyBase because you want to install it with a newer version of SQL Server (PolyBase can be installed on only one SQL Server instance per computer).

Polybase one per computer error

It can be one in a few simple steps.

Feature uninstallation – Step by step
  1. Open Apps & features tool. To do it, search for “apps” in the Windows Search bar. Select Apps & features in the results.Apps and features
  2. Find SQL Server installation (version) you want to modify and click Uninstall button. If you have a few instances of the same SQL Server version, then later you will have the possibility to decide which one you want to modify.
  3. You will be warned that “This app and its related info will be uninstalled”. Don’t worry, it won’t uninstall everything. You need to confirm your decision by clicking the Uninstall button one more time. That will start SQL Server uninstaller.Apps and features - warning
  4. When you confirm, then SQL Server uninstaller window will popup. To continue you need to choose the Remove option.SQl Server add repair remove
  5. As a next step, you need to choose the SQL Server instance you want to modify.Uninstall SQL Server feature - select instance
  6. After choosing an instance, you will see a Feature Selection pane with a list of all installed features. By default, they are not selected. You need to select features you want to uninstall. In my case this is PolyBase.
    Uninstall SQL Server feature - select features
  7. On the next window, you will see the summary of changes that will be applied. You also get the path to the ConfigurationFile.ini file. If you want or need you can use it for unattended uninstallation. To continue, click the Remove button.
    Uninstall SQL Server feature - final confirmation
  8. On the next window, you can observe the removal progress. Uninstallation may take a few minutes.
    Uninstall SQL Server feature - removal progress
  9. When removal is completed you will see its status and also will get the link to the log file. To close this window click the Close button.
    Uninstall SQL Server feature - removal done

That’s it! I hope you find it useful!

-Marek

Share it:
Facebooktwittergoogle_plusredditpinterestlinkedintumblrmailFacebooktwittergoogle_plusredditpinterestlinkedintumblrmail

Leave a Reply

Your email address will not be published. Required fields are marked *