Solved

Trouble Upgrading SQL 2000 to SQL 2008 R2 SP1

Posted on 2012-03-19
3
785 Views
Last Modified: 2012-08-14
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.
0
Comment
Question by:mray77
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 

Author Comment

by:mray77
ID: 37739247
Am i better off simply doing a full install of SQL 2008 R2 SP1 and importing my SQL 2000 database?
0
 
LVL 40

Accepted Solution

by:
lcohan earned 500 total points
ID: 37739262
You can't upgrade from SQL 2000 to 2008 directly and yes, you would be better off to install SQL 2008, then use detach/attach or better(safer) backup/restore from 2000 to 2008.
I suggest you also script all SQL logins from old SQL 2000 and create then on the new SQL 2008 as logins are at SQL level but inside SQL dbs as well.
0
 

Author Closing Comment

by:mray77
ID: 37739327
Perfect. Thanks for the info!
0

Featured Post

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question