As trivial as uninstalling or removing a feature from Microsoft SQL Server 2008 may seem, I find that if you don’t do this often enough, the screens presented to you during the removal process are unclear and may have you second guess on whether you’re going to accidentally uninstall the whole SQL instance. Since most of the products I work with use Microsoft SQL Server in some way, this post serves to document what the uninstall or removal of a feature such as Reporting Services looks like:
Open up Programs and Features or Add and Remove Programs depending on whether you’re using Windows Server 2003 or 2008, right click on Microsoft SQL Server 2008, and select Uninstall/Change:
Select the Remove option from the list and continue:
Note: I found the options listed in this window to be extremely unclear. The Remove option has the description: “Choose this option to remove the product.” which appears to suggest this will remove the whole SQL instance.
The SQL Server 2008 installing will launch:
Continue with the wizard as it checks the operating system:
The next screen will allow you to select the SQL instance you would like to remove features from:
Once you’ve selected the instance, you will now see the list of features installed so you can use the checkboxes beside them to uninstall the feature:
For the purpose of showing the whole process in this example, I’ve selected Reporting Services from the list and clicked next:
The SQL installation wizard will perform some validation tests:
The following is the last screen to turn back so make sure you review the summary to make sure you’ve selected the features you intend to remove:
Once you’ve clicked on the Remove button in the above screenshot, the removal will begin:
Pretty simple right? It may seem simple here but I can imagine the potential stress people get when clicking through the screens leading up to the one with the list of features installed and not knowing whether the wizard will start uninstalling SQL. I hope these screenshots help anyone out there would like to know exactly what the process of removing features from a SQL Server 2008 instance looks like.