Microsoft KB Archive/320873

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

Article ID: 320873

Article Last Modified on 1/15/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Desktop Engine (Windows)
 * Microsoft SQL Server 2000 Desktop Engine

-



This article was previously published under Q320873



Important This article contains information about how to modify the registry. Make sure to back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows registry

IN THIS TASK

 * SUMMARY
 * Remove Windows Installer references to installed products
 * Remove files and folders
 * Clean up the registry keys
 * REFERENCES



SUMMARY
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 &quot;More Information&quot; 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.

back to the top



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

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

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

If the MSDE 2000 instance is a named instance, you can find the ProductCode key value in the following registry key:

 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:

  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 </li>  For example, remove the MSDE 2000 program folder for a default instance:

<pre class="fixed_text">\Program Files\Microsoft SQL Server\MSSQL\Binn </li>  For example, remove the MSDE 2000 program folder for a named instance:

<pre class="fixed_text">\Program Files\Microsoft SQL Server\MSSQL$<INSTANCENAME>\Binn </li></ul>

back to the top

Clean up the registry
Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall your operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry 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:


 * 1) For an MSDE 2000 named instance, remove the following key:


 * 1) 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:


 * 1) Remove the SQLServer Service registry key.

For an MSDE 2000 default instance, remove the following:

For an MSDE 2000 named instance, remove the following:


 * 1) Remove the SQLServerAgent Service registry key:

For an MSDE 2000 default instance, remove the following:

For an MSDE 2000 named instance, remove the following:

back to the top

<div class="references_section">