Networks

Question

Upgrading SQL 2005 to SQL 2008 (in place)

After spending 2 days on this issue, I am now stuck. I have a test machine that I wish to practise performing in-place upgrades from SQL Server 2000 to 2005 to 2008 AND from 2000 to 2008 directly.Tech Specs- Windows Server 2003 R2 x64- Intel Core i7 920 2.67GHz- 8GB RAM

For the practise, I installed 2 instances of SQL 2000 x86 Standard and then installed SP4 on both.- Alpha2kTo2k5- Bravo2kTo2k8

I proceeded to upgrade Alpha to SQL 2005 and managed to do so without a hitch. I then applied SP3 to the 2005 instance.

Now this is where i got stuck. The next page is the "Select Features" page. At the top of the form it says "It Is Not Possible to change the SQL Server features to be upgraded in this release". The Featurs area is greyed out, which I kinda expected, but the only features listed are the following:- Shared Features- Redistributable Features

If I click on Next, the Disk Usage summary says that only 16Mb of drive space will be required for my selections, so clearly something is missing.

If I (hopefully so) continue and finish the upgrade, my instances are still as they were before. Nowhere was I asked which instance I want to upgrade.

All Answers

Start or search

Create a new discussion

If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.

Post type

Subject title

Topic Tags

Select up to 3 tags (1 tag required)

Cloud

Piracy

Security

Apple

Microsoft

IT Employment

Google

Open Source

Mobility

Social Enterprise

Community

Smartphones

Operating Systems

Windows

Mac

Malware

Tablets

Networking

Browser

Hardware

Software

Web Developerment

Linux

Off Topic

Message Body

Track this discussion and email me when there are updates

Please note: Do not post advertisements, offensive material, profanity, or personal attacks. Please remember to be considerate of other members. If you're new to the TechRepublic Forums, please read our TechRepublic Forums FAQ. All submitted content is subject to our Terms Of Use.