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

MORE INFORMATION

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&displaylang=en

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://msdn.microsoft.com/library/default.asp?url=/library/en-us/msi/setup/msizap_exe.asp

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 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}

back to the top

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

back to the top

Clean up the registry

WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

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>

back to the top