Security Update for SQL Server 2005 Service Pack 3 (KB970892) could not be installed

Question

Auto updates picked up this update to install but it wouldn't install. I tried doing it manually with no success. Anyone run across this?I have the service pack 2 with updates already. What would cause this?
Johnny

Answer 1

Same problem. Under "Add/Remove Programs" this (KB970892) is shown as Installed.
Still it keeps prompting to install it, and then the installation is failing.
I didn't find a solution yet, and it's annoying.
Kolio
BTW, when I chek for Update's History it is shown as Failed?!

Answer 2

Same here, tried twice but still not installing!

Answer 3

Same here.

Answer 4

Here is my personal solution: The security update shows as Installed on Add/Remove Programs. That makes me feel better:)
I just checked the box on the reminder, so it's not going to show again. I hope MS will resolve the issue with the next update.
Downside: there is not guarantee, I am protected:(

Answer 5

I'm experiencing the same issue.  It keeps re-prompting me to install the update, and then after it installs I get:

The following updates were not installed:

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

Answer 6

Actually, I just solved this on my machine.  I had the SQL Server service set to 'disabled'.  I set it to manual, started the service, applied the update again and it worked.

Answer 7

How did you enable the SQL server?

Answer 8

Go to start --> RUN --> Type in services.msc

Check them at SERVICES.MSC window.

Go to sql related services right click and set them to automatic in the general tab.

SQL RELATED services:

SQL SERVER (SQLEXPRESS)
SQL SERVER FULL TEXT SEARCH
SQL SERVER VSS WRITER
and other servies that start with SQL ..

---

Thanks, Leks

Answer 9

My System taken the same problem'
Tip':Look at  Path'( your-individual-Path)=sample' c:\programms\SQL Server Edition'  
               if your c:'section is 'Komprimiert'gona to decompress
the folder:=Sql Server Edition
After this' the installation of the Update will correctly be done of the install-application 



Note'- My System was taking alright after doing'.



               Good Luke

Answer 10

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.

Answer 11

Thanks for this. It worked like a charm for me.

Answer 12

YES!!!  Finally.   All hail to Sir Nicoli!   This solves weeks of messing around!