Trouble Upgrading SQL 2000 to SQL 2008 R2 SP1
Posted on 2012-03-19
We are running SQL 2000 on Windows serer 2003. Currently we are only utilizing one database; which is for our time and attendance system. We have a custom SQL application that requires SQL 2005 or newer, so we purchased SQL 2008 R2 SP1.
I obtained my ISO from Microsoft for SQL 2008 R2 SP1. I opened it using Magic Disk, and was able to extract the 3 Executables, SQL 2008 x86, x64, and IA64. I'm attempting to install using x86.
During install of Microsoft SQL Server 2008 R2 Service Pack 1...SQL Server 2008 R2 update, select next. Licensing Terms, next. Select Features (blank), select next. Then i get an error. There are validation errors on this page. Click OK to close this dialog box. Review errors at the bottom of the setup page, then provide valid parameters or click help for more information.
At the bottom of the screen, i see the message: There are no SQL Server Instances or shared features that can be updated on this computer.
I have also attempted to upgrade using SQL 2008 SP3. Same results.