sql server 2012 upgrade cannot select default instance

Question

I am trying to upgrade SQl Server 2008 Express with Advanced Tools to SQL Server 2012 Standard.

The problem is, the upgrade wizard, will not let me select the DEFAULT INSTANCE "MSSQLSERVER".

There are two Instances currently; "SQLEXPRESS" (which was installed by an application) and "MSSQLSERVER", the default which was installed by me - Express with Advanced tools.

The problem is - I can only select "SQLEXPRESS" or shared components It will not let me select the "MSSQLSERVER" Instance ID - even though it is listed in the Installed Instances grid.

On the select instance screen "default instance" radio button is grayed out.

Am I being stupid and blind ? Why can I not select the default instance ?

"SQLEXPRESS" is version 10.2.4000.0

"MSSQLSERVER" is version 10.50.1600.1 as is the shared components

Any ideas on where my ignorance lies greatly appreciated !

gbn · Accepted Answer · 2013-06-11 14:30:55Z

0

You'll need to apply Service Pack 1 (at least, SP2 is available too) to bring the version up to 10.50.2500 (at least, .2500 is SP1).

Your current 10.50.1600 is RTM and an upgrade from this is not supported.

FYI, the SQLEXPRESS instance is at SP2 already: 10.50.4000 (or 10.0.4000 if not R2)

answered Jun 11, 2013 at 14:30

gbn

434k84 gold badges602 silver badges690 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

bbaley Over a year ago

actually - SQLEXPRESS is 10.2.4000 not 10.50.4000 if that makes a difference

bbaley Over a year ago

which is weird - I don't even see that in the versions list... hmmmm.

gbn Over a year ago

A known issue: connect.microsoft.com/SQLServer/feedback/details/624341/…

Collectives™ on Stack Overflow

sql server 2012 upgrade cannot select default instance

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related