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

Discussion in 'Windows Update' started by managemybusiness, Oct 16, 2009.

  1. The above update has failed; does anyone know either how to resolve this
    issue or disable the update requirement
     
    managemybusiness, Oct 16, 2009
    #1
    1. Advertisements

  2. managemybusiness

    JR Guest

    I'm having the same problem. KB970892 won't install. I'm running XP. Home
    Editon 2002 SP3
     
    JR, Oct 16, 2009
    #2
    1. Advertisements

  3. managemybusiness

    JR Guest

    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).
     
    JR, Oct 16, 2009
    #3
  4. managemybusiness

    Bert Hyman Guest

    In =?Utf-8?B?bWFuYWdlbXlidXNpbmVzcw==?=
    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).
     
    Bert Hyman, Oct 16, 2009
    #4
  5. Not down loading for me either.
     
    Darrell Clarke, Oct 16, 2009
    #5
  6. managemybusiness

    Dr. Mike S Guest

    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
     
    Dr. Mike S, Oct 16, 2009
    #6
  7. managemybusiness

    JR Guest

    This doesn't seem to apply to me, as my folder is not compressed, just
    checked. :(
     
    JR, Oct 16, 2009
    #7
  8. managemybusiness

    Dr. Mike S Guest

    JR:

    Is the color of the folder name blue uner C:/Programs? If so, uncheck the box
     
    Dr. Mike S, Oct 16, 2009
    #8
  9. managemybusiness

    JR Guest

    No, nothing is blue, everything is uncompressed


     
    JR, Oct 16, 2009
    #9
  10. managemybusiness

    Dr. Mike S Guest

    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.
     
    Dr. Mike S, Oct 16, 2009
    #10
  11. managemybusiness

    vpjana Guest

    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, Oct 16, 2009
    #11
  12. managemybusiness

    vpjana Guest

    Oh, and I should've noted that I'm running Vista.
     
    vpjana, Oct 16, 2009
    #12
  13. managemybusiness

    JR Guest

    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.
     
    JR, Oct 16, 2009
    #13
  14. managemybusiness

    TracyLee Guest

    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.
     
    TracyLee, Oct 17, 2009
    #14
  15. managemybusiness

    Dr. Mike S Guest

    SORRY TO ALL. I SHOULD HAVE NOTED THAT I AM RUNNING WIN XP PROFESSIONAL.
     
    Dr. Mike S, Oct 17, 2009
    #15
  16. managemybusiness

    Woly Guest

    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)
     
    Woly, Oct 19, 2009
    #16
  17. managemybusiness

    bcamax Guest

     
    bcamax, Oct 21, 2009
    #17
  18. 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, Oct 22, 2009
    #18
  19. 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, Oct 22, 2009
    #19
  20. 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.

     
    David Kochkerian, Oct 22, 2009
    #20
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.