Monday, October 22, 2007

sql 2005 sp2 921896 failed

Well, I ran into a nice issue while trying to install SQL 2005 SP2 on a server that already has Hotfix 921896 installed. A big blaring error which causes the database engine upgrade to abort and generating a new level of headache. After much, much searching I found a workaround on the MSDN forums for it. Apparently the fix is to go through with the SP2 update and let it error out, then change a registry key to fool the system into thinking that everythings cool and re-running the service pack again. The second time I ran the SP2 update, the database engine was updated properly.

"Even when you complete the installation, the parameter Resume(HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MicrosoftSQL\Server\MSSQL.1\Setup) in the registry stays at 1 instead of 0. Youhave to change it to 0 and then it works." - markwyz1

See the last post on this page:

You may ask why I'm reposting the whole solution here. To put it simply, there's not a whole lot of references to this fix on the web but there are a whole lot of hits with no solution.

No comments: