Upgrading SQL Server 2008 R2 "Express Edition" from SP1 to SP2

Hi,
I'm trying to upgrade an SQL Server 2008 R2 Express Edition from SP1 to SP2. I downloaded the installation file, run through the setup steps, and I rebooted the server when it asked in the end. But I still see the file version of the 'sqlservr.exe" file stayed the same, ' 10.50.2500.0'.

Currently installed version: 10.50.2500.0 (2008 R2 SP1) Express Edition
The version I need to have: 10.50.4000 (2008 R2 SP2) Express Edition

According to MS download, the file I used to upgrade to SP2 is SQLServer2008R2SP2-KB2630458-x64-ENU.exe (http://www.microsoft.com/en-us/download/details.aspx?id=30437).

MS also have the SQL 2008 R2 Express Edition with SP2 download but when I run it, it doesn't give me option to upgrade the current install. It asks me if I want a new installation or add features.

Please let me know if anyone knows how I can upgrade this SQL Server toSP2.

Thanks in advance.
Sahap YuzerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Hypercat (Deb)Commented:
You should have seen a window as part of the service pack installation that enabled you to choose to upgrade a particular SQL instance.   Are you sure that you chose the correct instance?
Sahap YuzerAuthor Commented:
Hi,
In both installations, it's not showing me any option to upgrade the SQL instance. Attached are the screenshots of what I see.

Thanks.
SQLServer2008R2SP2-KB2630458-x64-ENU.JPG
SQLEXPR-x64-ENU.JPG
Hypercat (Deb)Commented:
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Hypercat (Deb)Commented:
And at what point in the installation process do you get that screen.  Is it immediate, or after you accept the license terms?
Sahap YuzerAuthor Commented:
Yes it is. I'm attaching the screenshot of the Add/Remove Programs and the version of the sqlservr.exe .
SQL-Installs.JPG
SQL-Version.JPG
Hypercat (Deb)Commented:
Sorry - I see that it's quite evident the step you're on.  You apparently have SQL Express, not full SQL, so you need to download the service pack for that version. Use this link, if it's not the same as the one you used before, and continue on past the installation type screen after you select your current instance to upgrade:

http://www.microsoft.com/en-us/download/details.aspx?id=30438

It should show you the features you already have installed and show that it will upgrade the already installed features.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Sahap YuzerAuthor Commented:
After. It's the 3rd step in the install wizard, attached are the first and second steps.
Capture1.JPG
Capture2.JPG
Sahap YuzerAuthor Commented:
If I select the "Add features to an existing instance of SQL Server 2008 R2 (Capture3.jpg), the "Feature Selection" screen shows the "Database Engine Services" unchecked (Capture4.jpg). That means it will install a new instance if I continue (Capture5.jpg and Capture6.jpg)
Capture3.JPG
Capture4.JPG
Capture6.JPG
Capture5.JPG
Vitor MontalvãoMSSQL Senior EngineerCommented:
I don't think you have SQL Server installed at all.
Can you check in the Services if there's a SQL Server service?
Hypercat (Deb)Commented:
Looking at your screen captures, it definitely looks as though you don't have SQL 2008 R2 installed.  You might have a different version installed, or you might not have SQL installed at all.  Check your Services list to see if SQL services are running.  Also, check the Programs list to see if you have any SQL tools installed (like SQL Server Management Studio, SQL Server Configuration Manager, etc.) and what versions are installed.
Sahap YuzerAuthor Commented:
I agree it seems like SQL is not installed or it is not detected  but I can see the SQL Server Service is running and they are listed under installed programs. (See attached screenshots)
SQL1.JPG
SQL2.JPG
SQL3.JPG
Vitor MontalvãoMSSQL Senior EngineerCommented:
That seems to be another edition of SQL Server. Isn't a SQL Server Express instance.
Sahap YuzerAuthor Commented:
I tried both regular 2008 R2 SP2 install and Express 2008 R2 SP2 install. They both don't recognize it as upgradeable SQL Server installation.

When I run the setup, it does recognize the installed instance, see attached.
Installed-Instance.JPG
Hypercat (Deb)Commented:
From looking at your screen capture of your installed programs, it looks like the SQL client and SQL browser software are showing the upgraded version.  There's no version displayed for the SQL server software itself - or at least I can't see it on the screen capture perhaps because it's highlighted.  Can you open the SQL Server management studio on the server and see what version it shows?

In the meantime, I'm going to try the upgrade on one of my SQL servers that's still on SP1 and see what happens.
Sahap YuzerAuthor Commented:
That's a good idea. I just installed the SQL 2008 R2 Management Studio and it does say the Express Edition, see attached.
Version.JPG
Hypercat (Deb)Commented:
After running the update, my SQL server shows exactly the same versions as yours in the Programs menu.  When I open the management studio it shows the updated version there:

Sql Mgmt Studio showing version info
Hypercat (Deb)Commented:
So, did you run the update version for SQL Express rather than full SQL?  My server is full SQL, so I ran the version you originally said you downloaded, but I posted a link to a version specifically for SQL express in one of my earlier posts.
Sahap YuzerAuthor Commented:
Yes I did, I tried the one in your link which was the same as my original Express SP2 Update I run. Still no luck..
Vitor MontalvãoMSSQL Senior EngineerCommented:
After install SQL Server Express Edition you should have an instance called \EXPRESS. If you don't have it is because isn't installed at all.
Sahap YuzerAuthor Commented:
I've done some research and I think the issue is with the way SQL Express Edition is installed.
It appears that SQL was installed as part of a 3rd party software that needed local SQL instance.

After spending whole day searching the internet, I saw only one discussion about people having same issue because the way 3rd party installer installs it.

Thanks hypercat, I think your directions would've resolved the issue if this was a regular SQL install.
Hypercat (Deb)Commented:
It's great that you figured it out.  I would not have expected that to happen.  However, if the installation was somehow customized by the 3rd party company, I can believe it.  If there's some compelling reason that you want to upgrade, you could contact them and ask if they have a procedure to move their database to a new instance of SQL 2008 R2 Express or to SQL 2012 Express. That way, you could install the new version or instance so that it's a clean, manageable install and then move the database over to it.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.