Microsoft KB Archive/914157

= Error message when you open SQL Server Enterprise Manager after you uninstall the SQL Server 2005 Backward Compatibility Components: &quot;Snap-in failed to initialize&quot; =

Article ID: 914157

Article Last Modified on 11/2/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Personal Edition
 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 2000 Enterprise Edition
 * Microsoft SQL Server 2000 Developer Edition
 * Microsoft SQL Server 2000 Workgroup Edition

-



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



SYMPTOMS
Consider the following scenario. You install the Microsoft SQL Server 2005 Backward Compatibility Components on a computer where SQL Server 2000 is installed. If you uninstall the SQL Server 2005 Backward Compatibility Components from the computer and then try to open SQL Server Enterprise Manager, you receive the following error message:

Snap-in failed to initialize.

Name: - not available -

CLSID:{00100100-1816-11D0-8EF5-00AA0062C58F}



CAUSE
This problem occurs because the following changes are made to the system after you uninstall the SQL Server 2005 Backward Compatibility Components:
 * The  registry subkey is removed from the registry.
 * The registration for the Sqlmmc.dll file is broken.



WORKAROUND
To work around this problem, use one of the following methods.

Method 1
 Reinstall the SQL Server 2005 Backward Compatibility Components.

To download the SQL Server 2005 Backward Compatibility Components, search for &quot;SQL Server 2005 Backward Compatibility Components&quot; on the following Microsoft Download Center Web site:

http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

 Click Start, click Run, type regsvr32 &quot; :\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlmmc.dll&quot;, and then click OK.

Note  is a placeholder for the drive where you installed SQL Server 2000.

Method 2
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.  Click Start, click Run, type regedit, and then click OK. Locate the following registry subkey:

 Right-click the ClientSetup registry subkey, point to New, and then click String Value.</li> Rename the registry subkey that you just created SqlPath, and then press ENTER.</li> Double-click the SqlPath registry subkey, and then type :\Program Files\Microsoft SQL Server\80\Tools in the Value data box.</li> Click OK, and then close Registry Editor.</li> Click Start, click Run, type regsvr32 &quot; :\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlmmc.dll&quot;, and then click OK.</li></ol>

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

<div class="moreinformation_section">

MORE INFORMATION
The SQL Server 2005 Backward Compatibility Components package includes the latest versions of the Data Transformation Services (DTS) 2000 runtime, SQL-DMO, Decision Support Objects (DSO), and SQL Virtual Device Interface (SQLVDI). These versions have been updated for compatibility with SQL Server 2005 and include all fixes through SQL Server 2000 Service Pack 4 (SP4).

Keywords: kbsql2005tool kbexpertiseadvanced kbtshoot kbprb KB914157

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.