Page 1 of 1

SQL Error: Snap-in unable to initialize

Posted: Wed Mar 01, 2006 3:14 pm
by gilthanaz
[Problem]
Sometimes Windows (specially 2003 Server) messes up when registering needed dll's to the system, ending in you getting error messages like missing dll's, or just that a snap-in for the MMC could not be initialized (in this case, the snap-in for the Enterprise Manager that comes with SQL Server 2000).

[Solution]
Register the missing dll's by hand, if they are on the HDD. If not, download them from Microsoft and place them to %WINNT%/system
In this case, the following command solved the problem:

Code: Select all

regsvr32 sqlmmc.dll
This gets the dll reregistered in the registry, and the programs will be able to make the proper calls again.