PRB: Error Message: "The snap in that has been selected has failed to initialize" Occurs When You Open SQL Enterprise Manager (315007)

RESOLUTION

To resolve this problem, use these steps:

1. 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:
   1. 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.
   2. Rename the existing \Mssql7\Binn\SQL Server Enterprise Manager.msc file so you can restore the file to the original state if necessary.
   3. From the x86\Binn folder on your SQL Server 7.0 CD, copy the Sqlem.msc file to your Mssql7\Binn folder.
   4. Rename the new Sqlem.msc file to SQL Server Enterprise Manager.msc.
2. 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.
3. 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.
4. Restart the computer for the changes to take effect.

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.