Solution to SQL Server 2005 SP2 Upgrade Issue : KB921896 1603 29565

Try the following if you get errors when upgrading to SP2

  1. Give explicit (not inherited) Full Control permissions to “c:\program files\microsoft sql server\mssql.x\” for Administrators group
  2. Delete all the files in this folder: “c:\program files\microsoft sql server\90\setup bootstrap\log\hotfix”
  3. Change the “Resume” key in “HKLM\SOFTWARE\MICROSOFT\MICROSOFT SQL SERVER\MSSQL.1\SETUP” to 0
  4. Delete all the keys that end in “Group” from the same location in step 3 above. AGTGroup, SQLGroup, FTSGroup

As usual…messing with your registry can hurt your machine, be careful and don’t blame me if something bad happens :)

Jon