How to select the proper SQL Server instance when upgrading from SQL Express 2008 to SQL Express 2008 R2

Question

I am trying to upgrade from SQL Express 2008 to SQL Express 2008 R2 to enable the full text indexing feature. During the upgrade, at the "Select Instance" step, the database that should be upgraded is not present in the drop down list.

Below the drop down there is a section titled "Installed instances". There are 4 items in this list, 3 SQL Servers and one entry for "shared components".

The drop down list contains 2 items, the first SQL Server in the "installed instances" list and the "shared components" but it does not list the other 2 SQL Servers.

The SQL Server that is included in the drop down is a Express Edition version 10.1.2531.0. The Shared Components version is 10.50.1600.1.

The 2 SQL Servers that are not appearing in the list are both Express Editions, version 10.52.4000.0.

Why aren't these 2 SQL Servers showing up in the list that allows me to specify the instance to upgrade?

Here is a screenshot of the step I am referencing: enter image description here

Thanks!

When you upgrade to a new version of SQL, you are upgrading a SQL instance. Not a database, per se. An instance of the Database Engine is a copy of the sqlservr.exe executable that runs as an operating system service. Each instance manages several system databases and one or more user databases. Each computer can run multiple instances of the Database Engine. Applications connect to the instance in order to perform work in a database managed by the instance. — Fuck StackOverflow
– Fuck StackOverflow, Commented Mar 19, 2014 at 19:16
@DMason - Does this mean that selecting the SHAREPOINT instance will also upgrade the other instances that are listed? — RacerNerd
– RacerNerd, Commented Mar 19, 2014 at 19:19
No. You can only upgrade one instance at a time. That's what the "Select Instance" step in the installation wizard is prompting you for. — Fuck StackOverflow
– Fuck StackOverflow, Commented Mar 19, 2014 at 19:20
So this brings me back to the original question... Why are the middle two database engines not available in the drop down list? — RacerNerd
– RacerNerd, Commented Mar 19, 2014 at 19:21
The SQL instances that are version 10.52.4000.0 are already SQL Server 2008 R2 (with SP2). You can't "upgrade" them. Does that make sense? sqlmag.com/sql-server/recent-sql-server-build-numbers — Fuck StackOverflow
– Fuck StackOverflow, Commented Mar 19, 2014 at 19:25

Fuck StackOverflow · Accepted Answer · 2014-03-19 19:38:37Z

1

You can't upgrade the SQL instances that are version 10.52.4000.0 to SQL Express 2008 R2 because they are already SQL Server 2008 R2 (with SP2).

Check out a list of SQL Server build numbers for more details.

answered Mar 19, 2014 at 19:38

Fuck StackOverflow

5,0462 gold badges26 silver badges25 bronze badges

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

Collectives™ on Stack Overflow

How to select the proper SQL Server instance when upgrading from SQL Express 2008 to SQL Express 2008 R2

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related