Windows SBS 2003 - KB948110 fails to install

I finally worked out how to get that blasted KB948110 patch for SQL that keeps popping up on SBS 2003 servers via Windows Update.

It would fail to install, and repeatedly asks to install. After doing a bit of research, this forum:

http://social.technet.microsoft.com/forums/en-US/systemcenterupdates/thread/1009693a-8498-49c1-9012-350749e75ce3/#page:2

gave me the clue to solve it. First I removed ADMT (Active Directory Migration Tool) that we had on that server for a previous domain migration, and the comment re - changing MSSQL$SBSMONIOTORING service from Disabled to Manual, made me enable and run the service.

Then I ran the security patch, and finally installed. Now no more annoying Windows Update nagging!

Windows Update Fails After SP3 install

I have had an issue with fresh XP installs + SP3. After SP3 is installed, Windows Updates fail to install.

This has happened on multiple installs now. Fresh and old installs.

So I had to one of these ones: http://support.microsoft.com/kb/555989

1. Create a batch file and copy the following contents in it and then double click on it to register modules.

regsvr32 c:\windows\system32\vbscript.dll
regsvr32 c:\windows\system32\mshtml.dll
regsvr32 c:\windows\system32\msjava.dll
regsvr32 c:\windows\system32\jscript.dll
regsvr32 c:\windows\system32\msxml.dll
regsvr32 c:\windows\system32\actxprxy.dll
regsvr32 c:\windows\system32\shdocvw.dll

2. Restart the Windows Update and Automatic service

3. Stop the Cryptographic Service

4. Remove the folder \Windows\System32\Catroot2

5. Rename the \Windows\SoftwareDistribution folder.

This above folder is the restoration point for Windows Update service.

6. Now restart the Cryptographic Service.

7. Create another batch file and put the following lines in it and then double click on it to register the modules:

regsvr32 /s Softpub.dll
regsvr32 /s Mssip32.dll
regsvr32 /s Initpki.dll
regsvr32 softpub.dll
regsvr32 wintrust.dll
regsvr32 initpki.dll
regsvr32 dssenh.dll
regsvr32 rsaenh.dll
regsvr32 gpkcsp.dll
regsvr32 sccbase.dll
regsvr32 slbcsp.dll
regsvr32 cryptdlg.dll
regsvr32 Urlmon.dll
regsvr32 Shdocvw.dll
regsvr32 Msjava.dll
regsvr32 Actxprxy.dll
regsvr32 Oleaut32.dll
regsvr32 Mshtml.dll
regsvr32 msxml.dll
regsvr32 msxml2.dll
regsvr32 msxml3.dll
regsvr32 Browseui.dll
regsvr32 shell32.dll
regsvr32 wuapi.dll
regsvr32 wuaueng.dll
regsvr32 wuaueng1.dll
regsvr32 wucltui.dll
regsvr32 wups2.dll
regsvr32 wups.dll
regsvr32 wuweb.dll
regsvr32 jscript.dll
regsvr32 atl.dll
regsvr32 Mssip32.dll

Your Windows Update should work.