Security Update for SQL Server 2005 Service Pack 3 (KB970892)

The above update has failed; does anyone know either how to resolve this
issue or disable the update requirement

I'm having the same problem. KB970892 won't install. I'm running XP. Home
Editon 2002 SP3

This is the windowsupdate log of the event.

2009-10-16 10:40:19:680 1036 b68 Agent *************
2009-10-16 10:40:19:680 1036 b68 Agent ** START ** Agent: Installing
updates [CallerId = AutomaticUpdates]
2009-10-16 10:40:19:680 1036 b68 Agent *********
2009-10-16 10:40:19:680 1036 b68 Agent * Updates to install = 1
2009-10-16 10:40:20:241 1036 b68 Agent * Title = Security Update for SQL
Server 2005 Service Pack 3 (KB970892)
2009-10-16 10:40:20:241 1036 b68 Agent * UpdateId =
{85B03E42-B575-493B-84C6-3E313D3406EA}.100
2009-10-16 10:40:20:241 1036 b68 Agent * Bundles 1 updates:
2009-10-16 10:40:20:241 1036 b68 Agent *
{D73323ED-8E80-4829-81D1-5875CCDDB238}.100
2009-10-16 10:40:27:952 1036 b68 Handler Attempting to create remote handler
process as NANJUL4\JR in session 0
2009-10-16 10:40:28:173 1036 b68 DnldMgr Preparing update for install,
updateId = {D73323ED-8E80-4829-81D1-5875CCDDB238}.100.
2009-10-16 10:40:33:150 1184 4a8 Misc =========== Logging initialized
(build: 7.4.7600.226, tz: -0700) ===========
2009-10-16 10:40:33:150 1184 4a8 Misc = Process:
C:\Windows\system32\wuauclt.exe
2009-10-16 10:40:33:150 1184 4a8 Misc = Module:
C:\Windows\system32\wuaueng.dll
2009-10-16 10:40:33:150 1184 4a8 Handler :::::::::::::
2009-10-16 10:40:33:150 1184 4a8 Handler :: START :: Handler: Command Line
Install
2009-10-16 10:40:33:160 1184 4a8 Handler :::::::::
2009-10-16 10:40:33:160 1184 4a8 Handler : Updates to install = 1
2009-10-16 10:41:17:924 1184 4a8 Handler : WARNING: Command line install
completed. Return code = 0x0000737d, Result = Failed, Reboot required = false
2009-10-16 10:41:17:924 1184 4a8 Handler : WARNING: Exit code = 0x8024200B
2009-10-16 10:41:17:924 1184 4a8 Handler :::::::::
2009-10-16 10:41:17:924 1184 4a8 Handler :: END :: Handler: Command Line

Is the SQL Server service actually running?

The update will fail if it's not, with something like this in the System
event log:

Windows Update Agent Event_ID 20

Installation Failure: Windows failed to install the following update
with error 0x80070643: Security Update for SQL Server 2005 Service Pack
3 (KB970892).

The answer is:

Your Microsoft SQL Server folder is likely compressed to save hard drive
space.

Go to your C: Drive

Then to Programs

It is likely that all of your folders are blue, rather than black meaning
they are compressed. Updates to the Microsoft SQL Server folder will not
load in compressed folders.

Right click on the Microsoft SQL Server folder and go to properties

Click on Advanced

Uncheck the third box that says: "Compress contents to save disk space."

Apply this setting to the folder, subfolders and files (second radio button)

Apply this setting, and go back to your Desktop.

Now the update will load perfectly.

This doesn't seem to apply to me, as my folder is not compressed, just
checked.

Is the color of the folder name blue uner C:/Programs? If so, uncheck the box

I only have one other idea.

Sometimes the update loads partially. Go to Control Panel....Add/Remove
Progtams and Check Show Updates.

Scroll down to Microsoft SQL Server 2005. Is the update KB970892 listed
underneath?

If so, uninstall it from the Add/Remove programs and then reinstall it.

I hope this helps. Sorry the other fix did not work for you.

I am having the same issue. I can't get this update to install. I tried both
of the fixes listed here and I still get an error code 64C. No idea what this
means, but the update will not install.

Thanks for your help Dr. Mike. No it didn't partially install, already had a
look for that. Anyway SQL isn't needed on this PC so I just uninstalled it
all, problem solved.

I do not understand. My vaio is on
vista. My errors are 646 & 643; KB973709, KB972581 & KB974234 &
microsoft.netframework1.1servcepack1 ( I have serv.pk 2). I have read most of
thes messages. I am not computer saavy at all. So most of what you guys are
talking about, I don't understand. Can anyone, help in plain language how to
resolve this update issue? I don't know if it is messing up my computer or
not. Sorry this is so long.

Someone more with the same problem. KB970892 failed with error code
0x80070643. Running sql desktop engine sp3 on windows xp. After uninstalling
and re-installting the sql server the problem was gone - but it returned
after the next windows update.

Folder compression is disabled. What else could cause this error?

To resolve this issue, do the following:

1. Go to Run, type regedit, and click ok, or press Enter.
2. Back up your registry, if you don't know how to do this, google it...
3. In Regedit, go to [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.1\Setup]
[Note that if you have multiple instances of MSSQL installed, the reg key
might be different for you]
4. find the Resume REG_DWORD, and change its decimal value from 1, to 0.
5. install the update, and restart the machine.

If you don't want to install this update using the automatic update
(WUAUCLT), you can download the hotfix directly from microsoft, just google
"download KB970892 ". you will still need to manually change the registy
"Resume" value, or else the hotfix will fail to install...

Berry, to answer your question, the MSSQL service is operational when you try
to install the hotfix, when the hotfix runs, it stops the service during the
installation so that it can overwrite some older files, and in the end it
should start the service again. but since the update is failing, it is not
operating the way that it's designed, and thus does not restart the service.

Same Issue on 3 machines.

1* Windows 7 Ultimate
1* Windows Server 2003 R2 Standard (x86)
1* Windows Server 2003 R2 Standard (x64)

I am new and I am having a problem downloading Security Update
for SQL Server 2005 Service Pack 3 (KB970892) HELP!!!

I'm having the same problem with Vista Bus SP1. I read where, and I had just
done it, that it wouldn't install to a compressed directory. I expanded it
back - still no joy.

And did you bother reading ANY of the other 30 posts in this thread?

changing the registry the way it's mentioned in this thread did not
work for me on an win 2k3 x64 machine, any other recommendations?

That fix worked for me., I uninstalled the KB970892 and then went to windows
update. It found the KB970892 & installed it. Hopefully this is the end of
it for me.

[eslusher]

This solved it for me. Now maybe my Business Contact Manager will stay up.

Thanks in advance. I have read over the posts and nothing here seems to be what my log shows.

2009-11-14 13:49:53.26 spid11s The Service Broker protocol transport is disabled or not configured.
2009-11-14 13:49:53.26 spid11s The Database Mirroring protocol transport is disabled or not configured.
2009-11-14 13:49:53.32 spid11s Service Broker manager has started.
2009-11-14 14:20:07.59 Server Server resumed execution after being idle 1782 seconds: user activity awakened the server. This is an informational message only. No user action is required.
2009-11-14 14:20:08.10 spid11s Service Broker manager has shut down.
2009-11-14 14:20:08.32 spid5s SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required.
2009-11-14 14:20:08.32 spid5s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.

I begin having the problem at "Sevice Broker" manager.

I don't even believe I need this update but I don't want to miss anything for future adjustments.