Windows Update fails after installing Sql Server 2008 R2 due to Office 2003 Web components

Question

Hi all.

Ok, here's an interesting story that occupied 2 days of my life. Hopefully can save you much pain. Read to the bottom to see the simple solution.

I have a Windows Server Enterprise sp2 x64 machine (copyright 2007 I assume this means windows server 2008) which worked fine. I installed sql server 2008 R2 Data Center on it and Windows Update would fail thereafter with error code 0x8024402F. Looking in windowsUpdate.log, I would see

2012-04-14 12:16:27:921  372 fa0 PT +++++++++++  PT: Synchronizing server updates  +++++++++++
2012-04-14 12:16:27:921  372 fa0 PT   + ServiceId = {7971F918-A847-4430-9279-4A52D1EFE18D}, Server URL = https://www.update.microsoft.com/v6/ClientWebService/client.asmx
2012-04-14 12:16:29:067  372 fa0 PT WARNING: SyncUpdates failure, error = 0x8024400D, soap client error = 7, soap error code = 300, HTTP status code = 200
2012-04-14 12:16:29:067  372 fa0 PT WARNING: SOAP Fault: 0x00012c
2012-04-14 12:16:29:067  372 fa0 PT WARNING:     faultstring:Fault occurred
2012-04-14 12:16:29:067  372 fa0 PT WARNING:     ErrorCode:ConfigChanged(2)
2012-04-14 12:16:29:067  372 fa0 PT WARNING:     Message:(null)
2012-04-14 12:16:29:067  372 fa0 PT WARNING:     Method:"http://www.microsoft.com/SoftwareDistribution/Server/ClientWebService/SyncUpdates"
2012-04-14 12:16:29:067  372 fa0 PT WARNING:     ID:27ab396e-14d1-4c09-99b3-2e348a5143b6
2012-04-14 12:16:35:563  372 fa0 PT WARNING: ECP: Failed to validate cab file digest downloaded from http://download.windowsupdate.com/msdownload/update/common/2011/10/4821670_aeaf6cadce218f1c5ca47ddebf0e3820e6afa1eb.cab with error 0x80091007
2012-04-14 12:16:35:563  372 fa0 PT WARNING: ECP: This roundtrip contained some optimized updates which failed. New Update count = 29, Old Count = 30
2012-04-14 12:16:35:626  372 fa0 PT WARNING: Sync of Updates: 0x8024402f
2012-04-14 12:16:35:626  372 fa0 PT WARNING: SyncServerUpdatesInternal failed: 0x8024402f
2012-04-14 12:16:35:626  372 fa0 Agent   * WARNING: Failed to synchronize, error = 0x8024402F
2012-04-14 12:16:35:627  372 fa0 Agent   * WARNING: Exit code = 0x8024402F
2012-04-14 12:16:35:627  372 fa0 Agent *********
2012-04-14 12:16:35:627  372 fa0 Agent **  END  **  Agent: Finding updates [CallerId = AutomaticUpdates]
2012-04-14 12:16:35:627  372 fa0 Agent *************
2012-04-14 12:16:35:627  372 fa0 Agent WARNING: WU client failed Searching for update with error 0x8024402f
2012-04-14 12:16:35:627  372 1614 AU >>##  RESUMED  ## AU: Search for updates [CallId = {FD482679-659E-4ABF-BF45-2E4B78249CDF}]
2012-04-14 12:16:35:627  372 1614 AU   # WARNING: Search callback failed, result = 0x8024402F
2012-04-14 12:16:35:627  372 1614 AU   # WARNING: Failed to find updates with error code 8024402F
2012-04-14 12:16:35:627  372 1614 AU #########
2012-04-14 12:16:35:627  372 1614 AU ##  END  ##  AU: Search for updates [CallId = {FD482679-659E-4ABF-BF45-2E4B78249CDF}]
2012-04-14 12:16:35:627  372 1614 AU #############

After much pain, I finally traced this to Office 2003 Web Components which gets installed as part of sql server 2008 R2. I thought this was installed as part of Analysis Services or Reporting services, but installing just the sql server database service also installs Office 2003 Web Components.

If, after installing sql server 2008 r2 I then go into the control panel and uninstall office 2003 web components, windows update works again!

Yea!

If I find a need for office 2003 web components from this point on, I'll look for other ways to get it installed.

Hope this helps avoid you some pain.

Answer 1

 

Hello,

Office Web components is required by SQL Server 2008 R2 tools.

Downloading and installing the following update may have been the solution.

http://www.microsoft.com/download/en/details.aspx?id=1878

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 2

Hi Alberto,

Thank you for your suggestion. I'm a bit hesitant to try your approach since my system is now working properly despite not having Office Web Components 2003 (not sure what won't work without them). You suggested I install the update to Office Web components, but since my system no longer has Office Web components installed, I'm not sure the update will install. I'll mark your reply as the answer, but this message indicates it is untested.

Thanks

-- Hank