Welcome to MSSQL Forum!
MSSQL Forum - Discussions about Microsoft SQL Server

You are currently viewing our community forums as a guest user. Sign up or
Having an account grants you additional privileges, such as creating and participating in discussions.

Uninstalling SQL Server 2008

Discussion in 'Installation and Administration' started by Peter Schmitz, Oct 1, 2012.

  1. Peter Schmitz

    Peter Schmitz Administrator Staff Member

    To uninstall SQL Server 2008, open up your control panel, and select "Programs and Features" (using Windows 2008. On earlier versions, you have to use "Add or remove programs".

    uninstall sql server 01.png

    Double-click the Microsoft SQL Server 2008 installation (In my case, the one marked with (64-bit)). You will be prompted by Windows to confirm that the request is legit, and give permission to perform the action:

    uninstall sql server 02.png

    You will now see the SQL Server 2008 configuration menu, where the bottom option can be used to perform an uninstall. Click "Remove":

    uninstall sql server 03.png

    SQL Server will now check the settings of your installation. Depending on the speed of your server, this might take a bit.

    uninstall sql server 04.png

    When done, you will see a screen informing you whether your system passed all checks:

    uninstall sql server 05.png

    You can click the "Show Details" button for some additional information:

    uninstall sql server 06.png

    Or, by clicking on "Show detailed report", you can see a more extensive overview of the individual checks performed:

    uninstall sql server 07.png

    You can now select which instance or components of SQL Server you want to uninstall. In the screenshot, I only have a single instance installed:

    uninstall sql server 08.png

    Next, you will determine which features of SQL Server to uninstall. In my case, I only want to remove the engine, but leave the other tools intact:

    uninstall sql server 09.png

    Some additional checks will be performed, and once again you get a report showing the result of these checks. The screenshot shows the screen after clicking the "Show Details: button:

    uninstall sql server 10.png

    And, like before, a more detailed report can also be pulled up if desired:

    uninstall sql server 11.png

    You will now be shown a summary screen detailing the uninstall plan, based on your input:

    uninstall sql server 12.png

    Clicking "Remove" will commence the uninstall, during which you can follow the staus of the removal progress:

    uninstall sql server 13.png

    When it completes, you will be shown additional details about the uninstall:

    uninstall sql server 14.png

    And finally a screen confirming the uninstall finished:

    uninstall sql server 15.png

    At this point, I would recommend you to reboot the server, to clear up any potential leftovers from the uninstall.

    That's it. I hope you find this little tutorial useful.

Share This Page