Speaking in Code

Monday, October 06, 2008

Upgrade to SQL Server 2008

If you want to upgrade an older sql server to SQL Server 2008, and you're doing so on a computer that has 64-bit hardware, you may receive the message:
"There are validation errors on this page"

on the Select Features section of the upgrade wizard.

This may be because the Upgrade Wizard defaults to attempt to create a 64-bit instance of SQL Server, but you cannot upgrade from 32-bit SQL to 64-bit SQL.

The solution: Click the Options tab in the "SQL Server Installation Center" and choose 32-bit.