I have attempted the upgrade from SQL 2005 SP4 Standard Edition on a Windows server 2008 box. (Both are 32-bit.)
I got an error saying that the upgrade failed, and the error is detailed in the attached log file.
I don't want to uninstall SQL 2005 on this box, as it is being used for production. I simply wanted to do an in-place upgrade.
Next, I tried installing a fresh copy of SQL 2008 into a new instance. I was going to simply restore the backups of the 2005 databases into the new 2008 instance, in order to do a side-by-side upgrade.
But, I got the same error--just on doing an install.
Somebody suggested that the only way to do a successful upgrade from SQL 2005 to 2008 is to do so by conducting an installation of SQL 2008 on a new box and migrating backups of the 2005 databases from the old server. I have done this succesfully a lot of times, but I find it hard to believe that an upgrade of SQL 2008 requires a new box. It looks like that is the case, from what I'm seeing, however,
Any ideas on how to get past this and on how to conduct this upgrade on this box?