Try the following if you get errors when upgrading to SP2
- Give explicit (not inherited) Full Control permissions to “c:\program files\microsoft sql server\mssql.x” for Administrators group
- Delete all the files in this folder: “c:\program files\microsoft sql server\90\setup bootstrap\log\hotfix”
- Change the “Resume” key in “HKLM\SOFTWARE\MICROSOFT\MICROSOFT SQL SERVER\MSSQL.1\SETUP” to 0
- 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