Microsoft KB Archive/315007

= PRB: Error Message: &quot;The snap in that has been selected has failed to initialize&quot; Occurs When You Open SQL Enterprise Manager =

Article ID: 315007

Article Last Modified on 8/27/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q315007



SYMPTOMS
When you open SQL Server version 7.0 Enterprise Manager, this error message may occur:

The snap in that has been selected has failed to initialize.



RESOLUTION
To resolve this problem, use these steps:  Replace the SQL Server Enterprise Manager.msc file with the SQL Server Enterprise Manager.msc file on the SQL Server 7.0 CD. To replace the MSC file, use these steps:  Open the Task Manager. In the Task Manager dialog box, click Processes. Check and make sure that Mmc.exe is not listed as an active process. If Mmc.exe is listed as an active process, end the Mmc.exe process. Rename the existing \Mssql7\Binn\SQL Server Enterprise Manager.msc file so you can restore the file to the original state if necessary. From the x86\Binn folder on your SQL Server 7.0 CD, copy the Sqlem.msc file to your Mssql7\Binn folder. Rename the new Sqlem.msc file to SQL Server Enterprise Manager.msc.   Unregister the Dtsui.dll, Sqlns.dll, Sqldmo.sll, Sqldmo.dll, and Sqlmmc.dll files located in your Mssql7\Binn folder. For example, if the files reside in C:\Mssql7\Binn, you run the following from a command prompt to unregister the files: C:\> regsvr32 /u Mssql7\Binn\Dtsui.dll C:\> regsvr32 /u Mssql7\Binn\Sqldmo.dll C:\> regsvr32 /u Mssql7\Binn\Sqlns.dll C:\> regsvr32 /u Mssql7\Binn\Sqllex.dll C:\> regsvr32 /u Mssql7\Binn\Sqlmmc.dll NOTE: Mssql7\Binn is the default folder for SQL Server 7.0. If your SQL Server 7.0 installation is in another location, you must update the command with the appropriate path. </li>  Re-register the Dtsui.dll, Sqlns.dll, Sqldmo.dll, Sqldmo.dll and Sqlmmc.dll files located in your Mssql7\Binn folder. For example, if the files reside in C:\Mssql7\Binn, you run the following from a command prompt to register the files: C:\> regsvr32 Mssql7\Binn\Dtsui.dll C:\> regsvr32 Mssql7\Binn\Sqldmo.dll C:\> regsvr32 Mssql7\Binn\Sqlns.dll C:\> regsvr32 Mssql7\Binn\Sqllex.dll C:\> regsvr32 Mssql7\Binn\Sqlmmc.dll NOTE: Mssql7\Binn is the default folder for SQL Server 7.0. If your SQL Server 7.0 installation is in another location you must update the command with the appropriate path. </li> Restart the computer for the changes to take effect.</li></ol>

NOTE: If the error message still occurs after you implement the preceding steps, please contact Microsoft Product Support Services because a Product Support Professional needs to create a detailed investigation to troubleshoot the issue.

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in SQL Server 7.0.

Additional query words: snap-in SEM MMC EXE

Keywords: kbprb KB315007

-

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

© Microsoft Corporation. All rights reserved.