Friday, October 23, 2009

KB970892 solved - at least for me!

As I mentioned in early posts, Sage ACT 2009 (ACT 7) uses MS SQL Server Express 2005 and KB970892 failed to patch it. Someone anonymously posted a solution today and it works for me. Their solution of changing the registry entry makes perfect sense because if you dive into the patch log, you will see that it seems to think that SQL Server is not fully installed and it asks you to use add-remove programs to complete the installation.

By simply changing this registry entry from a numeric '1' to a '0' (zer0), you are apparently telling the patch that the original installation was completed correctly:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQLServer\MSSQL.1\Setup

Change the "Resume" value from a 1 to a 0.

(If you have multiple instances of MSSQL installed, the MSSQL.1 reg key might be different for you)

Now you should be able to install the update either from Windows Update or manually using the knowledge base patch that has a full user interface. I used the full user interface patch and you may need to stop your instance of SQL Server before the patch can be fully applied - it will tell you if you need to. I did not use the "silent" Windows Update patch.

A big THANK YOU to whoever figured this out and to the person who posted the solution here today!

5 comments:

cameron said...

Thank you!!!

Anonymous said...

Someone's a genius. After two days wasted and 20 attempts over 3 weeks, it works!

Anonymous said...

It works!!!
Thank you so much!

Anonymous said...

That was easy.
Thanks!

Anonymous said...

Thanks, it works also on Seven.