SQL Server 2000 snap-in initialization failure resolution _MSSQL

With SQL Server 2000 databases, the SQL Server snap-in initialization failure error occurs when you open Enterprise Manager:
Window name is: MMC
Initialization of SQL Server snap-in failed
Name: Microsoft SQL Enterprise Tube
clsid{00100100-1816-11d0-8ef5-00aa0062c58f}

On the internet for a long time most of the SQL Server snap-in solution is to reload the database, it is too cumbersome, basically did not find a pragmatic solution, and finally through their efforts finally found a quick SQL Server snap-in solution, Save the following contents as a. reg file with Notepad, and import the registry.

Copy Code code as follows:

Windows Registry Editor Version 5.00
[hkey_classes_root\clsid\{00100100-1816-11d0-8ef5-00aa0062c58f}]
@= Microsoft SQL Enterprise Manager snap-in

[Hkey_classes_root\clsid\{00100100-1816-11d0-8ef5-00aa0062c58f}\inprocserver32]
@= "C:\\Program Files\\Microsoft SQL Server\\80\\tools\\binn\\sqlmmc.dll"
"ThreadingModel" = "Both"

[Hkey_classes_root\clsid\{00100100-1816-11d0-8ef5-00aa0062c58f}\progid]
@= "Sqlmmc.1"

[Hkey_classes_root\clsid\{00100100-1816-11d0-8ef5-00aa0062c58f}\versionindependentprogid]
@= "Sqlmmc"

SQL Server2000 Enterprise Manager "Snap-in initialization failed"
After installing SQL Server 2000, open Enterprise Manager prompt snap-in initialization failed
Snap-in initialization failed
Name < unknown >
clsid:{00100100-1816-11d0-8ef5-00aa0062c58f}

Workaround:

Solve this problem by registering all SQL related files through batch processing. Paste the following content into Notepad for *bat file execution.

Copy Code code as follows:

@echo on
regsvr32 autoplt.dll/s
regsvr32 autowiz.dll/s
regsvr32 axscphst.dll/s
regsvr32 cdwtasks.dll/s
regsvr32 cdwtskui.dll/s
regsvr32 colctrl.dll/s
regsvr32 comnevnt.dll/s
regsvr32 ctasksui.dll/s
regsvr32 custtask.dll/s
regsvr32 dtsffile.dll/s
regsvr32 dtspkg.dll/s
regsvr32 dtspump.dll/s
regsvr32 dtsui.dll/s
regsvr32 dtswiz.dll/s
regsvr32 hhsetup.dll/s
regsvr32 objmgr.dll/s
regsvr32 pfclnt80.dll/s
regsvr32 pfutil80.dll/s
regsvr32 psdcscm.dll/s
regsvr32 sdiclnt.dll/s
regsvr32 semcomn.dll/s
regsvr32 semcros.dll/s
regsvr32 semdll.dll/s
regsvr32 semdts.dll/s
regsvr32 semexec.dll/s
regsvr32 semmap.dll/s
regsvr32 semnt.dll/s
regsvr32 semobj.dll/s
regsvr32 semrepl.dll/s
regsvr32 semsfc.dll/s
regsvr32 semsys.dll/s
regsvr32 semwebwz.dll/s
regsvr32 semwiz.dll/s
regsvr32 sqdedev.dll/s
regsvr32 sqldmo.dll/s
regsvr32 sqlftwiz.dll/s
regsvr32 sqlgui.dll/s
regsvr32 sqllex.dll/s
regsvr32 sqlmmc.dll/s
regsvr32 sqlns.dll/s
regsvr32 sqlqry.dll/s
regsvr32 sqlresld.dll/s
regsvr32 sqlsui.dll/s
regsvr32 sqlsvc.dll/s
regsvr32 sqlvdir.dll/s
regsvr32 stardds.dll/s
regsvr32 svrnetcn.dll/s

By Regsvr32 the DLL dynamic link files once again, you can resolve the problem that the SQL 2000 snap-in initialization failed.