Microsoft SQL Server 2005 Security Update Service Pack 2 KB970895 - Error Code 64C

Answered Microsoft SQL Server 2005 Security Update Service Pack 2 KB970895 - Error Code 64C

  • Monday, February 04, 2013 9:29 AM
     
     

    I am afraid I am not too clever at technology but the facts are as a follows.  Every day my system tries to install update Microsoft SQL Server 2005 Security Update Service Pack 2 KB970895 and it fails with error code 64C.  I am not sure that I even need the product, to be honest.  I have looked through the other similar errors but they seem to have different error codes and so I thought I had better send a fresh query.  The others seem to have sent some sort of log information but I am not even sure how to do that but if you need it let me know what to do and I will do it.

    Many thanks

    Ian


All Replies

  • Monday, February 04, 2013 10:59 AM
    Moderator
     
     

    Hello,

    You can try the following:

    http://support.microsoft.com/kb/971058

    If the above does not work, please share with us the summary.txt log file. The following article may help you locate the file on disk:

    http://technet.microsoft.com/en-us/library/ms143702(v=sql.90)  

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

  • Monday, February 04, 2013 1:05 PM
     
     

    Alberto,

    many thanks for your suggestions.  I followed the steps for the FIXIT program and ran it successfully and then retried to instal the update but unfortunately it failed with the same error. 

    Following your second hyperlink, I searched 'Everywhere' using advanced search in my files but I could not find the main log file which it says  is located in

    %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt - can you help me find this?

    Ian

  • Monday, February 04, 2013 1:17 PM
    Moderator
     
     

    Hello,

    Open the Command Prompt and execute the following command:

    CD \

    Then run the following command and you will see where the summary.txt log file is located
    K

    DIR summary.txt /s

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

  • Monday, February 04, 2013 1:28 PM
     
     

    Alberto,

    thank you for your patience.  I attach the contents of the file:

    Microsoft SQL Server 2005 9.00.4035.00
    ==============================
    OS Version      : Professional Service Pack 1 (Build 6001)
    Time            : Tue Jun 30 15:24:37 2009
     
    Machine         : IANCOOK-PC
    Product         :  
    Product Version :  
    Uninstall       : Successful
    Log File        : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0004_IANCOOK-PC_SQL.log
    --------------------------------------------------------------------------------
     
     Setup succeeded with the installation, inspect the log file completely for status on all the components.

    Time            : Tue Jun 30 15:24:48 2009

    I hope this helps

    Ian

  • Monday, February 04, 2013 1:56 PM
    Moderator
     
     

    Hello,

    The update applies to SQL Server 2005 SP2, but you have SQL Server 2005 SP3 installed already. Windows Updates keeps trying to install this old update that no longer applies to your computer.

    Please hide the update using the following procedure:

    1.Click Start, click All Programs, and then click Windows Update.

    2.Click Check for updates.

    3.After the scan for updates is complete, click the Optional updates are available link.

    4.In the Select the updates you want to install section, right-click the update that you want to hide, and then click Hide update.

    5.Click OK.

    6.Click Install Updates to install any additional updates that are selected. If no other updates are selected, close Windows Update.

    For more information about hiding updates, please read the following resources:

    http://support.microsoft.com/kb/952032#method2

    http://support.microsoft.com/kb/902992

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

  • Monday, February 04, 2013 2:29 PM
     
     Answered

    Alberto,

    many thanks for this step by step guide it is much appreciated.

    I have, I believe completed this as you have said and at this moment Windows Update says, Windows is up to date, there are no updates available for your computer.  So I believe this problem is fixed. Although I will no better tomorrow.

    Many thanks for all of your help.

    Ian