Solved

Trouble Upgrading SQL 2000 to SQL 2008 R2 SP1

Posted on 2012-03-19
3
783 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone 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

In this article I will describe the Detach & Attach 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.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
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…
Via a live example, show how to shrink a transaction log file down to a reasonable size.

789 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