WMI: Initialization failure - SQL 2000

This was and serious error that occured in one of the database servers affecting the databases operations.The  error occured in the SQL Server Agent where it displays an error saying "WMI: Initialization failure" when the dependencies tab is clicked.
This wasted a lot of valuable time in seaching for an answer. Thought of posting as it would be important to anyone who comes accross this issue.
To overcome the following error you have to create this bat file and run it.

------------------------------------------------------------------------

 @echo on cd /d c:\temp if not exist %windir%\system32\wbem goto TryInstall cd /d %windir%\system32\wbem net stop winmgmt winmgmt /kill if exist Rep_bak rd Rep_bak /s /q rename Repository Rep_bak for %%i in (*.dll) do RegSvr32 -s %%i for %%i in (*.exe) do call :FixSrv %%i for %%i in (*.mof,*.mfl) do Mofcomp %%i net start winmgmt goto End :FixSrv if /I (%1) == (wbemcntl.exe) goto SkipSrv if /I (%1) == (wbemtest.exe) goto SkipSrv if /I (%1) == (mofcomp.exe) goto SkipSrv %1 /RegServer :SkipSrv goto End :TryInstall if not exist wmicore.exe goto End wmicore /s net start winmgmt :End

---------------------------------------------------------------------------------------------
Paste the above code on a note pad and save it as FIXWMI.CMD and run the error machine.

0 comments:

Post a Comment

 
Copyright © My Beat