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

Unable to update - error code 0x737D
Any ideas how to fix?

Security Update for SQL Server 2005 Service Pack 3 (KB970892) is not
updating. Continues to come up as "failied"? Please help

same thing here. and the yellow shield with the "!" keeps coming back.

Is the server running?

I have the "SQLEXPRESS" version installed (it got installed with Visual
Studio), but don't usually have the service running unless I'm actively
working on a related project.

I had the update fail to install too until I remembered to start the
server, after which the update worked fine.

In my case, the System event log entry said "Installation Failure: Windows
failed to install the following update with error 0x80070643: Security
Update for SQL Server 2005 Service Pack 3 (KB970892)."

I'm getting same thing in Windows Vista Ultimate, error code I'm getting is
7358 "Windows Update encountered an unknown error". Also my remote desktop
access stopped working a couple of updates ago.

For a previous service pack

<title>Error message when you try to install a SQL Server 2005 service pack
or a SQL Server 2005 hotfix package: "Error 29528.
The setup has encountered an unexpected error while Setting Internal Properties"</title>
http://support.microsoft.com/kb/925976

(Microsoft Search for
0x7358 29528 SQL)


BTW you might find more informed help from a newsgroup which specializes
in SQL setup.

I copied this from another discussion group and it worked on my computer. I
am running XP Professional.

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.

My regedit was already set like this. So, now what?

Exactly same with me, I;d had that number set to 0, so that is not
issue which would apply to everyone. I downloaded patch from mic.
website but still won't work. I have tried the one, where you go to
remove programs, SQL server 2005 Change and try to install it from
here, but it was asking me to locate patch. So I located patch
downloaded from web BUT it only accepts msi files, and Microsoft patch
is named as msp. I think this is the issue, but I don't know how to
resolve it. I've tried almost all options available while searching
net but unsuccessful. I am so fed up with microsoft. This issue is
messing with my Eset smart security, with my printer, and every time i
swith my pc on it takes ages cause of these silly attempts to install
it. Please don't tell me there's no proffesionals to help us here and
solve this issue. I am not talking about 10 ppl I am talking about
milions with same problem. Will Microsoft do something about it, or
they just don't care as usually???? IT MASTERS WHERE ARE YOU?

Same problem here, my regedit was already set to 0. I am afraid ther
are no IT professionals to help us here. This regedit thing doesn'
apply to everyone, so thanks for you participation and help but that'
not the issue

I had the same problem for weeks. It would runs for a bit and then
report it could not install. This was a pain because it would stop my
BackupExec and not restart it. So some of my backups that run passed 4
am would be stopped in their tracks. I tried all the suggestions on
the web, from uninstalling to reinstalling, but nothing worked until I
finally figured out that my problem was a missing local group. If you
look at the hotfix install log, summary.txt (which I found in C:
\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\)
you can see why the install failed. As you can see below mine was do
to a missing local group.

Error Number : 29512
Error Description : MSP Error: 29512 SQL Server Setup was
unable add user NT AUTHORITY\SYSTEM to local group CNTV
\SQLServer2005MSSQLUser$MYCOMPUTER$BKUPEXEC.

I searched this error in google and found a posting that suggested the
problem was that a previous install had removed the group and now when
this hotfix tries to add the user to the missing local group the
install fails. The solution is to convince the installer to recreate
the groups. This is accomplished by deleting some registry keys. If
you want to read the posting it is at this page
http://social.msdn.microsoft.com/For...c-3a40df6340a8,
but I will summarize below.

- Run the regedit.exe program.
- Back up your registry (use File -> Export and choose to export All)
- Find any of the keys listed below and delete them. Don't worry if
you do not have all the keys, I only had 2 of them.

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.X\Setup\SQLGroup
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.X\Setup\AGTGroup
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.X\Setup\FTSGroup
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.X\Setup\ASGroup

- Once I deleted the keys, I downloaded the hot fix instead of running
the Windows Update (http://download.microsoft.com/download/B/E/0/
BE0F87BC-37A4-4AB7-84C1-0E1A46F5463B/SQLServer2005-KB970892-x86-
ENU.exe).
- Last, I ran the hotfix and to my surprise it completed.

I hope this helps anyone in this group who has suffered with this
annoying hotfix.

Thanks for sharing the resolution.
Cross-post added to SQL Setup for its info.

I had this problems for weeks now and the above solution worked immediately.

Reg edit from Nic DiDonna worked for Small Business Server 2003 as well.

This worked to perfection and the instructions were right on the money.
Thanks a zillion..

This worked for me. thanks