Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

there are no features selected for upgrade during sql 2008 express r2 to sql standard r2 upgrade attempt

Posted on 2014-04-15
2
Medium Priority
?
4,343 Views
Last Modified: 2014-04-16
I am attempting to perform an "in-place" upgrade an instance of SQL Express 2008 R2 too SQL Server Standard R2 (both 64 bit) and I am installing 2008 Standard from an ISO that does not require a license key since we have a Microsoft "Enterprise Agreement" allowing us access to the volume license site and these special "no key required ISO's".

I am mentioning this because it means I cannot upgrade through "SQL Server Installation Center" choosing the "upgrade SQL edition" option or whatever it's called as that calls for a product key which I do not have or need.

When I run through the installer I pass all tests and get no errors, but when I get to the "select features" screen, I run into the following 2 images and am forced to cancel out of the installation.
error
screenshot
Now for a little background, I had originally downloaded the incorrect ISO's from Microsoft's volume license site on a couple different occasions and attempted to do this very upgrade with just the SQL 2008 R2 service pack 2 ISO about 5 times and had to cancel out every time obviously because it would say there were obviously no components to upgrade (finally figured out I have wrong installer). Then I tried about 4 different times using the "SQL Server Installation Server" where you simply upgrade your edition by entering a product key but had to cancel out every time due to not having a valid license key (In my trial and error phase).

Unfortunately this appears to have made about 10 folders in the %ProgramFiles%\Microsoft SQL Server\100\Setup Bootstrap\LOG\ directory as is mentioned in this KB from Microsoft which I am not certain I understand: http://support.microsoft.com/kb/955399

So to sum up, I have never had an installation complete with errors, I just have 10 aborted installations due to no product key or trying the wrong installation ISO to begin with, neither letting me get very far at all in the installation process. I have since found the correct installer ISO and am getting further than ever but can't get past the "select features" window I showed above.

I am messing with SQL for the first time ever here and it's in a production environment so I would really like to keep it as simple as possible to not risk screwing up any existing config options, which is why I am trying to do the in-place upgrade. I would really appreciate any suggestions or if anyone can clarify that KB above, maybe it actually would get me past the issue I am experiencing? Thanks!
0
Comment
Question by:IRRexperts
[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 Comments
 
LVL 3

Accepted Solution

by:
mlsbraves earned 2000 total points
ID: 40003205
I recently did an edition upgrade from SQL 2008 R2 Express to Standard(Volume License). Here is the guide I used:
http://databasebestpractices.com/edition-upgrade-sql-server-2008-r2-express-standard-edition/

Make sure when you run the ISO to go Maintenance --> Edition Upgrade

I wasn't forced to enter a product key, just click next.
0
 

Author Closing Comment

by:IRRexperts
ID: 40005780
Exactly what I needed, worked perfectly. Thanks!
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

660 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