Updates failing.

[BrassMonkey]

Hi everyone,

A Windows update could not be installed (Error Code 42D9):

Microsoft SQL Server 2005 Express Edition Service Pack 3

So, I downloaded it from:
Download details: SQL Server 2005 Express Edition SP3

I installed it, but the update was still showing and it still wanted to install the update - but I thought that's what I just did manually! Why did it still want to install it?

I hid the update from the Windows Update screen.

The next day, two updates came in - security updates for:
Microsoft SQL Server 2005 Service Pack 3 and
Microsoft SQL Server 2005 Service Pack 2

The update for Service Pack 3 installed successfully but the update for Service Pack 2 failed (Error Code 733F).

I hid the Service Pack 2 update, but it keeps coming back!

What am I supposed to do?

Thanks in advance,

BrassMonkey

 

[Flavius]

1.Reset WU components in aggressive mode How do I reset Windows Update components?
2.Reset WU modules Repair & Fix Windows Updates with Fix WU Utility | The Windows Club
3.Run cmd.exe with administrative previlliges (right click on cmd.exe) as admin and type:

sfc /scannow

4.Run Readiness Tool Description of the System Update Readiness Tool for Windows Vista, for Windows Server 2008, for Windows 7, and for Windows Server 2008 R2
even if this tool don't solve problem it create CheckSur.log file in C:\Windows\Logs\CBS folder

If nothing help pack all files from C:\Windows\Logs\CBS folder and attache to post or upload on rapidshare.com

 

[BrassMonkey]

Hi Flavius,

Thanks for replying. I tried what you said, but it didn't work.

I followed the instructions and when it had finished I ran Windows Update. There was one important update - Microsoft SQL Server 2005 Express Edition Service Pack 3. I tried to install it but it failed again (Error Code 42D9).

I have attached the CBS files, as requested.

Thanks,

BrassMonkey

 

[Flavius]

Two things: 1) In your CheckSur.log

Checking Component Watchlist (f) CBS Watchlist Component Missing 0x80070002 amd64_bthmtpenum.inf_31bf3856ad364e35_0.0.0.0_none_7ff053f99479855b Microsoft-Windows-WPD7IP-SKU-Package~31bf3856ad364e35~amd64~~7.0.6002.18112.bthmtpenum Package registry presence failed, possibly an orphaned package on package watchlist (f) CBS Watchlist Component Missing 0x80070002 amd64_wpdfs.inf_31bf3856ad364e35_0.0.0.0_none_a5e566b2d3236f6d Microsoft-Windows-WPD7IP-SKU-Package~31bf3856ad364e35~amd64~~7.0.6002.18112.wpdfs Package registry presence failed, possibly an orphaned package on package watchlist (f) CBS Watchlist Component Missing 0x80070002 amd64_wpdmtp.inf_31bf3856ad364e35_0.0.0.0_none_9f92d6d487384aad Microsoft-Windows-WPD7IP-SKU-Package~31bf3856ad364e35~amd64~~7.0.6002.18112.wpdmtp Package registry presence failed, possibly an orphaned package on package watchlist (f) CBS Watchlist Component Missing 0x80070002 amd64_wpdmtphw.inf_31bf3856ad364e35_0.0.0.0_none_78371ba92ff2a242 Microsoft-Windows-WPD7IP-SKU-Package~31bf3856ad364e35~amd64~~7.0.6002.18112.wpdmtphw Package registry presence failed, possibly an orphaned package on package watchlist

+ from your CBS.log

2010-02-25 08:32:10, Info CBS Failed removing poqexec from Cbs key. hr: 0x80070002 2010-02-25 08:32:10, Info CBS Failed removing impactful-commit disabling value from CCP. hr: 0x80070002 2010-02-25 08:32:10, Info CBS Setting RollbackFailed flag to 0

These reported strings are orphaned.You have to remove them Download PSTools PsTools extract from this pack psexec.exe file and place it into C:\Windows\System32 Next run cmd.exe with admin previlliges (right click on cmd.exe as admin) and type: psexec -s -i -d regedit This command will run regedit from SYSTEM account level (not from your level), next find in registry following keys:
HKLM\Software\Microsoft\Windows\CurrentVersion\Component Based Servicing\ComponentDetect\amd64_bthmtpenum.inf_31bf3856ad364e35_0.0.0.0_none_7ff053f99479855b

HKLM\Software\Microsoft\Windows\CurrentVersion\Component Based Servicing\ComponentDetect\amd64_wpdfs.inf_31bf3856ad364e35_0.0.0.0_none_a5e566b2d3236f6d

HKLM\Software\Microsoft\Windows\CurrentVersion\Component Based Servicing\ComponentDetect\amd64_wpdmtp.inf_31bf3856ad364e35_0.0.0.0_none_9f92d6d487384aad

HKLM\Software\Microsoft\Windows\CurrentVersion\Component Based Servicing\ComponentDetect\amd64_wpdmtphw.inf_31bf3856ad364e35_0.0.0.0_none_78371ba92ff2a242 and give SYSTEM account full control for those keys.Next in above keys remove following strings:

in HKLM\Software\Microsoft\Windows\CurrentVersion\Component Based Servicing\ComponentDetect\amd64_bthmtpenum.inf_31bf3856ad364e35_0.0.0.0_none_7ff053f99479855b remove string Microsoft-Windows-WPD7IP-SKU-Package~31bf3856ad364e35~amd64~~7.0.6002.18112.bthmtpenum

in HKLM\Software\Microsoft\Windows\CurrentVersion\Component Based Servicing\ComponentDetect\amd64_wpdfs.inf_31bf3856ad364e35_0.0.0.0_none_a5e566b2d3236f6d remove string Microsoft-Windows-WPD7IP-SKU-Package~31bf3856ad364e35~amd64~~7.0.6002.18112.wpdfs

in HKLM\Software\Microsoft\Windows\CurrentVersion\Component Based Servicing\ComponentDetect\amd64_wpdmtp.inf_31bf3856ad364e35_0.0.0.0_none_9f92d6d487384aad remove string Microsoft-Windows-WPD7IP-SKU-Package~31bf3856ad364e35~amd64~~7.0.6002.18112.wpdmtp

in HKLM\Software\Microsoft\Windows\CurrentVersion\Component Based Servicing\ComponentDetect\amd64_wpdmtphw.inf_31bf3856ad364e35_0.0.0.0_none_78371ba92ff2a242 remove string Microsoft-Windows-WPD7IP-SKU-Package~31bf3856ad364e35~amd64~~7.0.6002.18112.wpdmtphw

example how it look one of this key (strings you have in right window)
2) CBS.log report also some issues with this hotfix

2010-03-11 08:41:46, Error Failed to find the CixTarget for Container package_for_kb973917_winpesrv~31bf3856ad364e35~amd64~~6.0.1.2.cat
2010-03-11 08:41:46, Error DpxException hr=0x80070002 code=0x020109
2010-03-11 08:41:49, Error Failed to find the CixTarget for Container package_for_kb973917_server~31bf3856ad364e35~amd64~~6.0.1.2.cat
2010-03-11 08:41:49, Error DpxException hr=0x80070002 code=0x020109
2010-03-11 08:41:49, Error Failed to find the CixTarget for Container package_for_kb973917_sc~31bf3856ad364e35~amd64~~6.0.1.2.cat
2010-03-11 08:41:49, Error DpxException hr=0x80070002 code=0x020109

Seems KB973917 is incorrectly installed.Uninstall this update,make sure you have correct data & time both in system and in BIOS and reinstall this hotfix again

3)It would be also well to reset WU components in aggressive mode How do I reset Windows Update components?
and WU libreries Repair & Fix Windows Updates with Fix WU Utility | The Windows Club

If nothing help empty C:\Windows\Logs\CBS folder,again run Readiness Tool and attache to post new CBS.log and CheckSur.log

 

[BrassMonkey]

Hi,

Still didn't work. It failed to install "Microsoft SQL Server 2005 Express Edition Service Pack 3". Same error code: 42D9. I have attached the new CBS.log and CheckSur.log

Thanks for your time with this. I really appreciate it.

BrassMonkey

 

[Flavius]

Nothing wrong in your logs now,please attache to post all files from %programfiles%\Microsoft SQL Server\100\Setup Bootstrap\Log folder.

 

[BrassMonkey]

Hi,

I don't have a "100" folder. I went to this location - C:\Program Files\Microsoft SQL Server - and could only find an "80" or "90" folder and there's no "Setup Bootstrap" folder in either of those.

However, I found this one - C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG - and I have attached the files.

Is that the right one? Or am I missing something?