Solved

Trouble Upgrading SQL 2000 to SQL 2008 R2 SP1

Posted on 2012-03-19
3
777 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
  • 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 39

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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
separate column 24 20
Export data with an insert trigger to a linked server 20 21
Convert int to military time 8 20
sql query Help 12 29
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

758 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now