Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

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

208 views
Skip to first unread message

sido

unread,
Oct 16, 2009, 5:30:01 AM10/16/09
to
Unable to update - error code 0x737D
Any ideas how to fix?
--
cairngorm

L

unread,
Oct 16, 2009, 9:04:17 AM10/16/09
to

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

stig86

unread,
Oct 16, 2009, 9:26:01 AM10/16/09
to


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

managemybusiness

unread,
Oct 16, 2009, 10:27:01 AM10/16/09
to
The above update has failed; does anyone know either how to resolve this
issue or disable the update requirement

Bert Hyman

unread,
Oct 16, 2009, 11:04:35 AM10/16/09
to
In news:A60A14B8-4D4A-4C6A...@microsoft.com =?Utf-
8?B?c3RpZzg2?= <sti...@discussions.microsoft.com> wrote:

>
>
> 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)."

--
Bert Hyman St. Paul, MN be...@iphouse.com

dtunstallnc

unread,
Oct 16, 2009, 11:55:02 AM10/16/09
to
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.

--
Don

JR

unread,
Oct 16, 2009, 1:54:01 PM10/16/09
to
I'm having the same problem. KB970892 won't install. I'm running XP. Home
Editon 2002 SP3

JR

unread,
Oct 16, 2009, 2:22:05 PM10/16/09
to
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
Install
2009-10-16 10:41:17:924 1184 4a8 Handler :::::::::::::
2009-10-16 10:41:17:924 1036 df8 AU >>## RESUMED ## AU: Installing update
[UpdateId = {85B03E42-B575-493B-84C6-3E313D3406EA}]
2009-10-16 10:41:17:924 1036 df8 AU # WARNING: Install failed, error =
0x80070643 / 0x0000737D
2009-10-16 10:41:18:194 1036 df8 AU Install call completed.
2009-10-16 10:41:18:194 1036 df8 AU # WARNING: Install call completed,
reboot required = No, error = 0x00000000
2009-10-16 10:41:18:194 1036 df8 AU #########
2009-10-16 10:41:18:194 1036 df8 AU ## END ## AU: Installing updates
[CallId = {19662FCD-8A61-447C-96F5-CD01921B762B}]
2009-10-16 10:41:18:194 1036 df8 AU #############
2009-10-16 10:41:18:194 1036 df8 AU Install complete for all calls, reboot
NOT needed
2009-10-16 10:41:18:194 1036 b68 Agent *********
2009-10-16 10:41:18:194 1036 b68 Agent ** END ** Agent: Installing
updates [CallerId = AutomaticUpdates]
2009-10-16 10:41:18:194 1036 b68 Agent *************
2009-10-16 10:41:22:931 1036 da4 Report REPORT EVENT:
{04BF35C7-4B76-4C01-9AF4-E5DD9B7D053C} 2009-10-16
10:41:17:924-0700 1 182 101 {85B03E42-B575-493B-84C6-3E313D3406EA} 100 80070643 AutomaticUpdates Failure Content
Install Installation Failure: Windows failed to install the following update

with error 0x80070643: Security Update for SQL Server 2005 Service Pack 3
(KB970892).

eagle231

unread,
Oct 16, 2009, 4:19:01 PM10/16/09
to

"dtunstallnc" wrote:

Same thing here with error code 0x7358, running XP Pro. Has anyone heard
about this issue?

Bert Hyman

unread,
Oct 16, 2009, 4:36:21 PM10/16/09
to
In news:232C6B66-E29F-47F4...@microsoft.com
=?Utf-8?B?bWFuYWdlbXlidXNpbmVzcw==?=
<managemy...@discussions.microsoft.com> wrote:

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

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).

--

Clarke@discussions.microsoft.com Darrell Clarke

unread,
Oct 16, 2009, 4:42:01 PM10/16/09
to
Not down loading for me either.

Mike S@discussions.microsoft.com Dr. Mike S

unread,
Oct 16, 2009, 5:16:01 PM10/16/09
to

"managemybusiness" wrote:

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

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.

Good luck,

Mike

JR

unread,
Oct 16, 2009, 5:47:01 PM10/16/09
to
This doesn't seem to apply to me, as my folder is not compressed, just
checked. :(

Dr. Mike S

unread,
Oct 16, 2009, 5:51:18 PM10/16/09
to
JR:

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

JR

unread,
Oct 16, 2009, 6:02:01 PM10/16/09
to
No, nothing is blue, everything is uncompressed

Dr. Mike S

unread,
Oct 16, 2009, 6:28:18 PM10/16/09
to
JR:

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.

vpjana

unread,
Oct 16, 2009, 6:39:01 PM10/16/09
to
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.

vpjana

unread,
Oct 16, 2009, 6:40:01 PM10/16/09
to
Oh, and I should've noted that I'm running Vista.

JR

unread,
Oct 16, 2009, 6:46:20 PM10/16/09
to
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.

Thanks again.

TracyLee

unread,
Oct 16, 2009, 8:31:18 PM10/16/09
to
Hello to all: Dr. Mike, JR, Vpjana et all. 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.

Dr. Mike S

unread,
Oct 16, 2009, 9:01:01 PM10/16/09
to
SORRY TO ALL. I SHOULD HAVE NOTED THAT I AM RUNNING WIN XP PROFESSIONAL.

kidrio

unread,
Oct 17, 2009, 6:29:01 AM10/17/09
to
M wrote : Ditto on failed update

Woly

unread,
Oct 19, 2009, 2:22:01 PM10/19/09
to
Hi all!

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?

Greetz
(Woly)

Robert Aldwinckle

unread,
Oct 20, 2009, 1:12:00 PM10/20/09
to
(cross-post added to SQL Setup)
"eagle231" <eagl...@discussions.microsoft.com> wrote in message news:B029BD9C-04B5-4058...@microsoft.com...


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&#58; &#34;Error 29528.
The setup has encountered an unexpected error while Setting Internal Properties&#34;</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. Cross-posting for convenience.


Good luck

Robert Aldwinckle
---


bcamax

unread,
Oct 21, 2009, 1:18:09 PM10/21/09
to

"Bert Hyman" wrote:

> .
> Interesting note - I'm getting the same thing without any error indicated, just "not installed." Watching the system as the update is being "installed", SQL Server 2005 starts out activated. At some point during the process however, it shuts down. A few seconds later, the window then indicates it was not installed. I'm running WinXP Pro as well.

Kochkerian@discussions.microsoft.com David Kochkerian

unread,
Oct 22, 2009, 2:44:14 PM10/22/09
to
Hi there,

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...

Best,
David

David Kochkerian

unread,
Oct 22, 2009, 2:52:01 PM10/22/09
to
Sorry for posting this twice, i didn't know that it wasn't the last page :)

Hi there,

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...

I had this issue on one of the servers of the company that I work for, and
it is a SharePoint server. I resolved it using the points described above.

Best,
David

David Kochkerian

unread,
Oct 22, 2009, 2:59:01 PM10/22/09
to
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.

Daniel Lüngen

unread,
Oct 23, 2009, 8:46:12 AM10/23/09
to
Same Issue on 3 machines.

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

Daniel

Jim Szatkowski, PE, NSPE

unread,
Oct 23, 2009, 3:56:01 PM10/23/09
to
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.
--
Jim Szatkowski, PE, NSPE
State of Idaho, IPELS

donphx

unread,
Oct 23, 2009, 10:20:23 AM10/23/09
to

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


--
donphx
Posted via http://ms-os.com Forum to Usenet gateway

PA Bear [MS MVP]

unread,
Oct 23, 2009, 7:05:31 PM10/23/09
to
And did you bother reading ANY of the other 30 posts in this thread?

http://groups.google.com/group/microsoft.public.windowsupdate/browse_frm/thread/572a42d21eae6fee

Dennis

unread,
Oct 23, 2009, 9:27:01 PM10/23/09
to
I copied this from another discussion group and it worked on my computer, I
am running XP

Hi there,

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...

Best,
David


"sido" wrote:

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

nicholasdidonna

unread,
Oct 24, 2009, 2:52:20 PM10/24/09
to

Hey all,

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.


Best of luck!

P.S. This is a lot faster and easier than calling Microsoft Customer Support. Trust me, I tried. Three times.

sido wrote:

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

16-Oct-09

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

Previous Posts In This Thread:

EggHeadCafe - Software Developer Portal of Choice
ASP.NET Map DataTable DataColumn To Class Properties
http://www.eggheadcafe.com/tutorials/aspnet/670bdb4f-0a15-40fa-a0eb-b81104bc27f9/aspnet-map-datatable-dat.aspx

nicholasdidonna

unread,
Oct 24, 2009, 2:54:21 PM10/24/09
to

Hey all,

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.


Best of luck!

P.S. This is a lot faster and easier than calling Microsoft Customer Support. Trust me, I tried. Three times.

eagle231 wrote:

"dtunstallnc" wrote:Same thing here with error code 0x7358, running XP Pro.
16-Oct-09

"dtunstallnc" wrote:


Same thing here with error code 0x7358, running XP Pro. Has anyone heard
about this issue?

Previous Posts In This Thread:

EggHeadCafe - Software Developer Portal of Choice

Slipstreaming and Unattended Windows Media Creation
http://www.eggheadcafe.com/tutorials/aspnet/6c050f8f-9b74-4fce-bdbe-4f37a6bdfdc5/slipstreaming-and-unatten.aspx

fermata

unread,
Oct 24, 2009, 6:44:35 PM10/24/09
to

Yes, I tried it too and it does work, except I got it from the person
above you who posted it here first.

Nicholas DiDonna;1589920 Wrote:
> Hey all,
>
> 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:


--
fermata
Posted via http://www.vistaheads.com

daluen

unread,
Oct 29, 2009, 3:42:45 AM10/29/09
to
Hi PA,
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?

regards,
Daniel

On 24 Okt., 00:05, "PA Bear [MS MVP]" <PABear...@gmail.com> wrote:
> And did you bother reading ANY of the other 30 posts in this thread?
>

> http://groups.google.com/group/microsoft.public.windowsupdate/browse_...


>
>
>
> donphx wrote:
> > Hello - I am new and I am having a problem downloading Security Update

> > for SQL Server 2005 Service Pack 3 (KB970892)  HELP!!!- Zitierten Text ausblenden -
>
> - Zitierten Text anzeigen -

Stephanie

unread,
Nov 4, 2009, 10:16:04 AM11/4/09
to

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


"Nicholas DiDonna" wrote:

> .
>

eslusher

unread,
Nov 5, 2009, 9:26:25 AM11/5/09
to

David Kochkerian;4661461 Wrote:
> 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...

Thanks!!!!

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


--
eslusher
------------------------------------------------------------------------
eslusher's Profile: http://forums.techarena.in/members/152003.htm
View this thread: http://forums.techarena.in/windows-update/1259372.htm

http://forums.techarena.in

renski33

unread,
Nov 6, 2009, 9:40:06 AM11/6/09
to
On Nov 4, 4:16 pm, Stephanie <Stepha...@discussions.microsoft.com>
wrote:
> >http://www.eggheadcafe.com/tutorials/aspnet/6c050f8f-9b74-4fce-bdbe-4...
> > .

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?
HEEEELP!!!!

renski

unread,
Nov 6, 2009, 9:46:39 AM11/6/09
to

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


--
renski
Posted via http://www.vistaheads.com

Jason Martinez

unread,
Nov 8, 2009, 11:49:01 PM11/8/09
to
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/Forums/en-US/sqlexpress/thread/c7d0a234-763b-4f9c-b7ec-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.

Robert Aldwinckle

unread,
Nov 10, 2009, 1:32:40 AM11/10/09
to

(cross-post added to SQL Setup)
"Jason Martinez" <ma...@jasonmartinez.com> wrote in message news:677d7846-0f11-42e1...@x6g2000prc.googlegroups.com...

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


Robert Aldwinckle
---


PhoenixRizes

unread,
Nov 14, 2009, 5:51:28 PM11/14/09
to

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.


Many many thanx!

J.


--
PhoenixRizes
------------------------------------------------------------------------
PhoenixRizes's Profile: http://forums.techarena.in/members/154864.htm

mbolbroe

unread,
Jan 24, 2010, 4:53:01 AM1/24/10
to

"Jason Martinez" wrote:

> .
>

JUST WANTED TO SAY THANK YOU!

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

midnitediamond

unread,
Feb 3, 2010, 1:22:01 PM2/3/10
to
Reg edit from Nic DiDonna worked for Small Business Server 2003 as well. Thanks


"Nicholas DiDonna" wrote:

> .
>

sdogru

unread,
Feb 16, 2010, 6:53:02 AM2/16/10
to

sdogru

unread,
Feb 16, 2010, 6:58:05 AM2/16/10
to

Michael

unread,
Feb 16, 2010, 2:46:19 PM2/16/10
to
2 for 2, moron!

--


"Don't pick a fight with an old man.
If he is too old to fight, he'll just kill you."


"sdogru" <sdo...@discussions.microsoft.com> wrote in message
news:183F359B-F5D1-4E93...@microsoft.com...

Lover@discussions.microsoft.com Dalmatian Lover

unread,
Feb 19, 2010, 11:56:01 AM2/19/10
to
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.

"Dr. Mike S" wrote:

> JR:
>
> 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.
>
> "JR" wrote:
>
> > No, nothing is blue, everything is uncompressed
> >
> >
> > "Dr. Mike S" wrote:
> >
> > > JR:
> > >
> > > Is the color of the folder name blue uner C:/Programs? If so, uncheck the box
> > >
> > > "JR" wrote:
> > >
> > > > This doesn't seem to apply to me, as my folder is not compressed, just
> > > > checked. :(


> > > >
> > > > "Dr. Mike S" wrote:
> > > >
> > > > >
> > > > >
> > > > > "managemybusiness" wrote:
> > > > >
> > > > > > The above update has failed; does anyone know either how to resolve this
> > > > > > issue or disable the update requirement
> > > > >

> > > > > 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.
> > > > >
> > > > > Good luck,
> > > > >
> > > > > Mike

PA Bear [MS MVP]

unread,
Feb 19, 2010, 3:27:02 PM2/19/10
to
Error code when you use Windows Update or Microsoft Update to install
updates on a computer that has SQL Server 2005 installed: "0x737D":
http://support.microsoft.com/kb/978597

PhoenixRizes

unread,
Feb 19, 2010, 5:03:08 PM2/19/10
to

> David Kochkerian
>
> Posts: n/a

> 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...

This worked for me. *G* Thank you!

PrairieNerd403

unread,
Feb 23, 2010, 1:13:02 PM2/23/10
to

On an x64 Machine navigate to
\HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL
Server\*instance* instead of the registry path indicated in the original post.

"daluen" wrote:

> .
>

davep

unread,
Mar 8, 2010, 6:29:02 PM3/8/10
to
This worked to perfection and the instructions were right on the money.
Thanks a zillion..

"Nicholas DiDonna" wrote:

> .
>

curtiseflush

unread,
Mar 11, 2010, 7:21:01 PM3/11/10
to
This worked for me. thanks
0 new messages