DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 955499 - Last Review: March 6, 2013 - Revision: 9.0

For a Microsoft SQL Server 2005 version of this article, see 909967  (http://support.microsoft.com/kb/909967/ ) .
For a Microsoft SQL Server 2000 version of this article, see 290991  (http://support.microsoft.com/kb/290991/ ) .

On This Page

INTRODUCTION

This article describes how to uninstall a stand-alone instance of Microsoft SQL Server 2008. When you follow the steps in this article, you also prepare the system so that you can reinstall SQL Server 2008.

Note To maintain or to update an instance of SQL Server 2008, you must be a local administrator who has permission to log on as a service.

More information

What to consider before you uninstall a stand-alone instance of SQL Server 2008

  • We recommend that you use the Add or Remove Programs feature in Control Panel to uninstall SQL Server.
  • On a computer that is running SQL Server 2008 together with earlier versions of SQL Server, Enterprise Manager and other programs that depend on SQL-DMO might be disabled. This issue may occur in the following situations:
    • Side-by-side installations of any combination of SQL Server 2008, SQL Server 2000, and Microsoft SQL Server 7.0 in which one or more of these instances is uninstalled
    • Side-by-side installations of SQL Server 2000 and SQL Server 2008 in which SQL Server 2000 is installed after SQL Server 2008
    This issue occurs when the registration for the SQL Server SQL-DMO COM library is removed.

    To re-enable Enterprise Manager and other programs that have SQL-DMO dependencies, register SQL-DMO. To do this, open a command prompt, type the following command, and then press ENTER:
    regsvr32.exe sqldmo.dll
  • Before you remove SQL Server components from a computer that has the minimum required amount of physical memory, make sure that the page file size is sufficient. The page file size must be equal to two times the physical memory. Insufficient virtual memory can cause an incomplete removal of SQL Server.
  • In SQL Server 2005, the SQL Server Browser was installed together with the Database Engine or Analysis Services in an integrated installation.

    In SQL Server 2008, the SQL Server Browser is a separate installation that is performed automatically with the Database Engine or Analysis Services. If you have multiple instances of SQL Server 2008, the SQL Server Browser is uninstalled automatically when the last instance of SQL Server 2008 is uninstalled.

    However, if SQL Server 2005 exists on the system together with one or more instances of SQL Server 2008, the SQL Server 2008 Browser is not removed automatically when the last instance of SQL Server 2008 is uninstalled. The SQL Server 2008 Browser that is installed together with SQL Server 2008 remains on the system to ease connections to the instance of SQL Server 2005.

    You can leave the SQL Server 2008 Browser installed together with SQL Server 2005. The SQL Server 2008 Browser will continue to function correctly.

    To uninstall all components of SQL Server 2008, you must uninstall the SQL Server 2008 Browser component by using the Add or Remove Programs feature in Control Panel. If you remove the SQL Server 2008 Browser when a SQL Server 2005 named instance is present, connectivity to SQL Server 2005 might be disrupted. In this situation, you can reinstall the SQL Server 2008 Browser by using one of the following methods:
    • Repair the instance of SQL Server 2005 by using the Add or Remove Programs feature in Control Panel.
    • Install an instance of the SQL Server 2005 Database Engine or Analysis Services.

What to do before you uninstall an instance of SQL Server 2008

  • Back up your data.

    You might have databases that you want to save in their present state. You might also want to save changes that were made to the system databases. In either situation, make sure that you back up the data before you uninstall SQL Server. Or, save a copy of all the data and the log files in a folder other than the MSSQL folder. (The MSSQL folder is deleted during the uninstallation process.)

    The files that you must save include the following database files.

    Note These files are installed as part of SQL Server.
    • Distmdl.*
    • Master.*
    • Mastlog.*
    • Model.*
    • Modellog.*
    • Msdbdata.*
    • Msdblog.*
    • Mssqlsystemresource.*
    • Northwind.* (This database is an optional installation.)
    • Pubs.*
    • Pubs_log.*
    • Tempdb.*
    • Templog.*
    • ReportServer[$InstanceName] (This file is the Reporting Services default database.)
    • ReportServer[$InstanceName]TempDB (This file is the Reporting Services default temporary database.)
  • Delete the local security groups.

    Before you uninstall SQL Server, delete the local security groups for SQL Server components.
  • Save or rename Reporting Services folders.

    If you use the SQL Server installation together with Reporting Services, save or rename the following folders and subfolders:
    • drive:\Microsoft SQL Server\MSRS10.SQL Server instance name\Reporting Services
    Notes
    • In these files, drive is a placeholder for the drive on which SQL Server 2008 is installed.
    • If you used the SSRS configuration tool to configure the installation, the names might differ from the names in this list. Additionally, the databases might be located on a remote computer that is running SQL Server 2008.
  • Delete the Reporting Services virtual directories.

    Use Internet Information Services (IIS) Manager to delete the following virtual directories:
    • ReportServer[$InstanceName]
    • Reports[$InstanceName]
  • Delete the ReportServer application pool.

    Use IIS Manager to delete the ReportServer application pool.
  • Stop all SQL Server services.

    We recommend that you stop all SQL Server services before you uninstall SQL Server components. Active connections can prevent successful uninstallation.
  • Use an account that has the appropriate permissions.

    Log on to the server by using the SQL Server service account or by using an account that has equivalent permissions. For example, you can log on to the server by using an account that is a member of the local Administrators group.

Note SQL Server setup is a complicated process. SQL Server setup modifies lots of registry keys and DLL files. SQL Server setup also installs and updates permission entries and service registrations. 

We test SQL Server setup procedures, both installation and uninstallation, in many configurations. However, we cannot test all configurations due to the number of third-party products and customer specific changes that can occur at the operating system level. Therefore, you may encounter rare circumstances that prevent successfully installing or uninstalling SQL Server by using the setup program.

Because of these complexities, the SQL Server Support team may recommend that you reinstall the operating system if the procedures outlined in this article do not help perform a clean uninstall of the SQL Server program. This helps provide a clean platform to reinstall SQL server on your system.
  1. Follow these steps, as appropriate for the version of Windows Server that you are running:

    Windows Server 2008
    1. Open the Programs and Features item in Control Panel. To do this, click Start, type appwiz.cpl in the Start Search box, and then click appwiz.cpl in the Programs list.
    2. In the Currently installed programs list, click Microsoft SQL Server 2008 or click Microsoft SQL Server 2008 (64 bit).
    3. Click Uninstall. The SQL Server Installation Wizard starts.
    Windows Server 2003
    1. Open the Add or Remove Programs item in Control Panel. To do this, click Start, click Run, type appwiz.cpl in the Open box, and then click OK.
    2. In the Currently installed programs list, click Microsoft SQL Server 2008 or click Microsoft SQL Server 2008 (64 bit).
    3. Click Remove. The SQL Server Installation Wizard starts.
  2. On the Component Selection - Uninstall page, select a server or a shared component that you want to remove.

    Click the Report button to view the list of SQL Server components and features that are installed. The report includes version information, edition information, update level information, and language information for each installed component and feature.
  3. Click Next.
  4. On the Confirmation - Uninstall page, review the list of components and features that will be removed, and then click Next. The Setup Progress page will display the status of the Setup program.
  5. On the Completing Setup page, click Finish to exit the Installation Wizard.
  6. Repeat steps 2 to 5 until all SQL Server 2008 components have been removed.

Applies to
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 Express with Advanced Services
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Standard Edition for Small Business
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Express
  • Microsoft SQL Server 2008 R2 Express with Advanced Services
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Standard Edition for Small Business
  • Microsoft SQL Server 2008 R2 Web
  • Microsoft SQL Server 2008 R2 Workgroup
  • Microsoft SQL Server 2008 R2 Datacenter
Keywords: 
kbsqlsetup sql2008relnoteuninstall sql2008relnote kbsetup kbuninstall kbexpertiseinter kbhowto KB955499
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support