?
Solved

Trouble Upgrading SQL 2000 to SQL 2008 R2 SP1

Posted on 2012-03-19
3
Medium Priority
?
795 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 40

Accepted Solution

by:
lcohan earned 2000 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses

840 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