t.lesh

Fixing a broken SQL Server 2005 Express

Ok, so I got this stupid error after WSUS 3 failed to start (after running fine for about 4 months) and HP Web Jetadmin 10.1 failed to install.  I had no clue what happened to WSUS, but the Jetadmin installation would fail while trying to configure SQL Server 2005 Express Edition.  Here is what happened and the solutions that I found to correct this.

1. Tried installing HP Web Jetadmin 10.1 and received this error during installation: The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine SRVRNAME Error:2147749896 (0x80041008)
   • Create the following batch 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
2. I was then able to get past the WMI error, but the SQL Express 2005 installation was still failing.  I fixed this by…
   • Download the installation package from
   • Manually extract the package to a temporary directory, SQLEXPR32.EXE /x:C:\Temp\SQLExpress2005
   • Open sqlncli.msi and select the Repair option.
3. The HP Web Jetadmin installation finally worked!
4. Still working on getting WSUS 3 fixed…