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

I have investigated the registry entry for this update and I have found that
my registry decimal value for the sql update is already set at 0 and so the
problem of the update not installing continues with the yellow shield
continually showing at the bottom of my screen. Of interest is that the
update does not show itself in the add/remove programs screen in the security
updates area. Can anyone assist please.

ozriverboy wrote:
> I have investigated the registry entry for this update and I have found
> that
> my registry decimal value for the sql update is already set at 0 and so
> the
> problem of the update not installing continues with the yellow shield
> continually showing at the bottom of my screen. Of interest is that the
> update does not show itself in the add/remove programs screen in the
> security
> updates area. Can anyone assist please.

One can only guess, given your subject and choice of words without
referencing any actual post, that you are referring to this solution?

To resolve this issue, do the following:

1. Start button --> Run --> type in:
regedit
--> click OK.

2. Back up your registry or at least the
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\ section.

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. Exit the Registry Editior.

6. Reboot.

7. Try to install again.

If you don't want to install this update using the automatic update, you can
download the hotfix directly from Microsoft:
http://www.microsoft.com/technet/sec.../MS09-062.mspx
(Choose the appropriate download.)


If that is so - please provide more information. Operating System (OS),
edition of OS, service pack level of OS and so on. If you have not tried
manually installing the update (downloading the installation file, running
it, etc) - it is highly recommended you do so.

--
Shenan Stanley
MS-MVP
--
How To Ask Questions The Smart Way
http://www.catb.org/~esr/faqs/smart-questions.html

"[In the US & CA] Please call 1-800-936-5700 (or 1-800-936-4900 and ask to
be routed to the SQL-Public Team) to open a free consumer support case.
There is no charge for support related to installing a Security Update.

"When you call please let them know that this has to do with Security
Bulletin MS09-062.

"If they try to charge you, please let them know that there is free support
for any issues with Security Updates."

Source:
http://groups.google.com/group/micro...fc180d9f9e71b9
and
http://groups.google.com/group/micro...beea74c983c1c6
--
~Robear Dyer (PA Bear)
MS MVP-IE, Mail, Security, Windows Client - since 2002
www.banthecheck.com


ozriverboy wrote:
> I have investigated the registry entry for this update and I have found
> that
> my registry decimal value for the sql update is already set at 0 and so
> the
> problem of the update not installing continues with the yellow shield
> continually showing at the bottom of my screen. Of interest is that the
> update does not show itself in the add/remove programs screen in the
> security updates area. Can anyone assist please.