How to: Uninstall an Existing Instance of SQL Server 2000 or 7.0

Use the following procedure to remove an existing instance of Microsoft SQL Server 2000 or SQL Server 7.0.

Before you begin, consider the following important information before you uninstall SQL Server:

On a computer running SQL Server 2005 along with previous SQL Server versions, Enterprise Manager and other programs that depend on SQL-DMO may be disabled. This may occur in the following situations:

  • Side-by-side installations of SQL Server 2005, SQL Server 2000, and/or SQL Server 7.0, where any of the versions is uninstalled.
  • Side-by-side installations of SQL Server 2000 with SQL Server 2005, where SQL Server 2000 is installed after SQL Server 2005.

This issue is due to removal of the registration for the SQL Server 2005 SQL-DMO COM library. To re-enable Enterprise Manager and other programs with SQL-DMO dependencies, register SQL-DMO by running 'regsvr32.exe sqldmo.dll' from a command prompt. For more information, see Troubleshooting an Installation of SQL Server 2005.

To uninstall an existing instance of SQL Server 

  1. Insert the SQL Server 2000 CD in your CD-ROM drive. If the CD does not autorun, double-click Autorun.exe in the root directory of the compact disc.

  2. Click SQL Server 2000 Components, and then click Install Database Server. Setup starts the SQL Server Installation Wizard. At the Welcome screen, click Next.

  3. In the Computer Name dialog box, click Local Computer or Remote Computer.

  4. In the Installation Selection dialog box, click Upgrade, Remove, or Add Components to an Existing Instance of SQL Server, and then click Next.

  5. In the Instance Name dialog box, the Default check box is selected if you have the default instance installed. If you want to uninstall a named instance, select it in the Instance Name list box, and then click Next.

  6. In the Existing Installation dialog box, click Uninstall your existing installation, and then click Next.

  7. Setup removes the selected installation. In the Uninstalling dialog box, click Next, and then in the Setup Complete dialog box, click Finish.

See Also


How to: Upgrade to SQL Server 2005 (Setup)

Help and Information

Getting SQL Server 2005 Assistance