How to manually remove a Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) instance

This step-by-step article describes how you manually remove a Microsoft SQL Server 2000 Desktop Engine (also known as MSDE 2000) instance. If you experience a problem when you try to remove an MSDE 2000 instance by using Add/Remove Programs in Control Panel, you can manually remove the instance instead. To manually remove MSDE 2000, follow the steps in the "More Information" section of this article.

Note: Use Add/Remove Programs in Control Panel to remove the SQL Server 2000 Desktop Engine (MSDE 2000) instance before you try to manually remove the instance.

Remove Windows Installer references to installed products

The steps in this section require the Windows Installer Software Development Kit (SDK) command-line tool Msizap.exe. To acquire this tool, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?familyid=A55B6B43-E24F-4EA3-A93E-40C0EC4F68E5 (http://www.microsoft.com/downloads/details.aspx?familyid=A55B6B43-E24F-4EA3-A93E-40C0EC4F68E5)

The Msizap.exe tool is also included in Microsoft Windows Server 2003 Support Tools. To install Windows Support Tools, open the Tools folder on the Microsoft Windows Server 2003 CD, and then double-click Suptools.msi.

After you install this tool, Msizap.exe is available in the Program Files\Microsoft Platform SDK\Bin folder.

For more information about the Msizap.exe tool, visit the following Microsoft Web site:

http://msdn2.microsoft.com/en-us/library/aa370523.aspx (http://msdn2.microsoft.com/en-us/library/aa370523.aspx)

Warning The Msizap utility may cause programs that were previously installed with the Windows Installer to fail. For more information, see the Platform SDK documentation.

Follow these steps to remove the MSDE 2000 installer references:

1. Determine the ProductCode for the MSDE instance that was installed. For more information about how to identify the ProductCode, use the ProductCode to Original Package Name mapping table that is in the following Microsoft Knowledge Base article:
   
   311762  (http://support.microsoft.com/kb/311762/ ) How to identify which MSI file was used for an existing MSDE installation
   
   For example, if the MSDE 2000 instance is a default instance, you can find the ProductCode key value in the following registry key:
   
   HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Setup
   
   If the MSDE 2000 instance is a named instance, you can find the ProductCode key value in the following registry key:
   
   HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<INSTANCENAME>\Setup
   
   
2. Use Msizap.exe to remove all Windows Installer information for the ProductCode of the MSDE 2000 instance. Type the following line at the command prompt:
   
   MSIZAP.EXE T {GUID}
   
   For example, if your MSDE 2000 instance has a ProductCode of E09B48B5-E141-427A-AB0C-D3605127224A, and you want to use Msizap.exe to remove the Windows Installer information, run the following command from the command prompt on your computer:
   
   MSIZAP.EXE T {E09B48B5-E141-427A-AB0C-D3605127224A}

Remove files and folders

Remove the MSDE 2000 instance data and program installation folders. You can find the root folder information for the default instance data folder in the SQLDataRoot registry key value under this registry key path:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Setup

• For example, remove the MSDE 2000 data folder for a default instance:
  

  \Program Files\Microsoft SQL Server\MSSQL\Data

• For example, remove the MSDE 2000 data folder for a named instance:
  

  \Program Files\Microsoft SQL Server\MSSQL$<INSTANCENAME>\Data

• For example, remove the MSDE 2000 program folder for a default instance:
  

  \Program Files\Microsoft SQL Server\MSSQL\Binn

• For example, remove the MSDE 2000 program folder for a named instance:
  

  \Program Files\Microsoft SQL Server\MSSQL$<INSTANCENAME>\Binn

Clean up the registry

Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
The Msizap.exe tool removes only Windows Installer specific keys or data for the ProductCode. It is best to manually remove the MSDE 2000 registry keys. Use Registry Editor to remove the following MSDE 2000 registry keys:

1. For an MSDE 2000 default instance, remove the following key:
   
   HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
   
2. For an MSDE 2000 named instance, remove the following key:
   
   HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<INSTANCENAME>
   
3. If the following registry key points to the MSDE 2000 instance ProductCode, remove the value InstanceComponentSet.x. For example, InstanceComponentSet.1 has a value that matches the ProductCode of Sqlrun01.msi:
   
   HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Component Set\InstanceComponentSet.1
   
   
4. Remove the SQLServer Service registry key.
   
   For an MSDE 2000 default instance, remove the following:
   
   HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer
   
   For an MSDE 2000 named instance, remove the following:
   
   HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQL$<INSTANCENAME>
   
   
   
5. Remove the SQLServerAgent Service registry key:
   
   For an MSDE 2000 default instance, remove the following:
   
   HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLServerAgent
   
   For an MSDE 2000 named instance, remove the following:
   
   HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLAgent$<INSTANCENAME>

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

For more information about MSDE 2000, visit the following Microsoft Web site:

http://www.microsoft.com/sql/prodinfo/previousversions/msde/prodinfo.mspx (http://www.microsoft.com/sql/prodinfo/previousversions/msde/prodinfo.mspx)