Programming Forums > Application Development > Visual Basic .NET

john Wesley · Jun 8th, 2006, 7:42 AM

I tried posting this through an old thread that was related but kept being hit with a message declaring an invalid link, and deciding this information is useful to quite a variety of people, im taking the action to have it accessible.

Recently i have had problems myself installing SQL Express E that i got bundled with VB.NET, and the installation prcedure couldnt finish correctly, instead it landed me with an error message of the context....

" The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine mymachine Error:2147749896 (0x80041008) "

after asking around i found this problem occurs quite regularly and looked into getting it fixed. i came across some information within the MSDN forums and to fix this specific problem continue with the following procedure....

Open Notepad then copy and paste the following into it...

(Toggle Plain Text)

FIXWMI.CMD 
------------------------ 

@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

Save this on your local disk as FIXWMI.cmd;
Open the command prompt and run, e.g; c:\FIXWMI.cmd
When you see the 'End' statement run the SQL installation again and the matter should be fixed.

NOTE: Be patient this batch file can take a few minutes to run through and may seem as if it has stopped - It is running.

Jun 8th, 2006, 7:42 AM	#1
john Wesley Hobbyist Programmer Join Date: May 2006 Location: United Kingdom Posts: 119 Rep Power: 3	WMI Config Settings Fixed for SQL I tried posting this through an old thread that was related but kept being hit with a message declaring an invalid link, and deciding this information is useful to quite a variety of people, im taking the action to have it accessible. Recently i have had problems myself installing SQL Express E that i got bundled with VB.NET, and the installation prcedure couldnt finish correctly, instead it landed me with an error message of the context.... " The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine mymachine Error:2147749896 (0x80041008) " after asking around i found this problem occurs quite regularly and looked into getting it fixed. i came across some information within the MSDN forums and to fix this specific problem continue with the following procedure.... Open Notepad then copy and paste the following into it... (Toggle Plain Text) FIXWMI.CMD ------------------------ @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 FIXWMI.CMD ------------------------ @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 Save this on your local disk as FIXWMI.cmd; Open the command prompt and run, e.g; c:\FIXWMI.cmd When you see the 'End' statement run the SQL installation again and the matter should be fixed. NOTE: Be patient this batch file can take a few minutes to run through and may seem as if it has stopped - It is running. __________________ Mona Lisa must of had the highway blues you can tell by the way she smiles..

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Programming Forums > Application Development > Visual Basic .NET

WMI Config Settings Fixed for SQL