For those that cant install SQL 2005 SP3 Hotfix KB970892
To clarify, the automatic updates method is not the method i have reccomended to resolve, as the offline method will provide clearer information in the result of an error, but will deal with the same issue.
You should already get the following in the log from a previous failed install:
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB970892_sqlrun_sql.msp.log
SQL Express Features :
Error Number : 29565
Error Description : MSP Error: 29565 SQL Server Setup cannot upgrade the specified instance because the previous upgrade did not complete. Start the Remote Registry service and go to Add/Remove Programs, select the Change button for Microsoft SQL Server 2005, and then select SQL instance YOUR_INSTANCE and complete the setup.
----------------------------------------------------------------------------------
(You should be able to find a summary.txt log in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\ that matches the time of the failed install.)
To Resolve:
Firstly close any dependant applications, and stop the SQL service instances you are trying to patch.(so you can avoid rebooting post install)
Open Regedit.
Navigate to HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL.*\Setup
(where * is the instance you are trying to patch)
Edit the DWORD Value "Resume" from 1 to 0
Exit Regedit.
Download the offline hotfix installer from [zie eerdere posting van mijn hand]
Apply the patch.
Restart any services etc if required.
Those users whos PCs have the update pending for install on reboot via automatic updates (and retry/fail on reboot) should then find it will clear.
