Windows 7 (SQL Server 2005) - Error Code: 66A (Can't install KB970892)

You will get the best help for any Update/Service Pack problem in the Windows Update Forum; link below:

http://social.answers.microsoft.com/Forums/en-US/vistawu/threads

When you repost there, kindly include any Error Codes, and exactly what happens when you attempt to Update.

That way you will receive the best help there.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 

For any Windows 7 questions:


http://social.answers.microsoft.com/Forums/en-US/category/windows7

Above link is to Windows 7 Forums, for questions about Windows 7.

All Windows 7 questions should be directed to/posted there.

You are in Vista Forums.

Cheers.

Hi tnguyen875,

Are you having issues in installing this particular update or any other updates?
To resolve this issue, do the following:
a. Click on Start, type regedit in the search box.

b. On the registry editor window, navigate to the below key:
[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)

c. Find the "Resume" (REG_DWORD) and change its decimal value from 1 to 0

d. Exit the Registry Editor.

e. Reboot.

f. Try to install the update again.

REGISTRY EDIT DISCLAIMER:

Important:  This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:

How to back up and restore the registry in Windows:http://support.microsoft.com/kb/322756 

You may also refer the below link and go through the suggestions provided by sparkly_flea on Monday, October 26, 2009 at 8:54 PM:

http://social.msdn.microsoft.com/Forums/en/sqlsetupandupgrade/thread/f42c5aeb-b284-4894-b5cd-8637e520119e 

Hope this helps.
Regards,
Manasa P – Microsoft Support.

Hi Manasa,

In the registry of my computer does not have the folder MSSQL.1 in the [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup] as you directed.   My that folder Microsoft SQL Server has only : 90, CMJ, SQLExpress.

Please help

Thank for your promptly response.

Hi Manasa:

I have the same problem so I'm search for a solution in he web so I found a Microsoft suggestion that indicates download and install manually the KB970892 (I have a Windows Vista Home Premium SP2 in english. Well the update was installed ok but the Updates Center still show the package like an important update and I can't delete it or install it. I follow your indications and found in my Registry the key that you named but the value it's 0 so Could you help me in order to be free for this fail? Please how do you need see about my system? The issues that I have at this moment it's that I need restart the Laptop each time that the package it's reported by the Update Center because at this time my SQL Server can't stabilish connection with the databases. By the way my SQL it's 2005 Standar.

Thank's a lot by the help.

Hi tnguyen875,

If it was not you may be an application installed the SQL Server by you (Visual Studio, Sharepoint and Dynamics CRM does). And the applications tend to install the 32 bit version of the product (SQL Server Express) thats why you can't apply the update.  Please try to use the 32 bit version of the KB970892 Update.

Hope this help.