Home > SQL > SQL 2008 R2 Edition Upgrade Architecture Mismatch

SQL 2008 R2 Edition Upgrade Architecture Mismatch

Recently I had to upgrade a SQL 2008 R2 Express edition to Standard.  I knew with SQL 2008 R2 this was very easy to do using the wizard.  However on the server I was trying to change the edition on I kept getting an error during the checks about architecture mismatch.  I thought this was weird since the installer includes both x86 and x64 versions and choose the correct version based on the OS.

Well it turns out the application that installed SQL Express installed the x86 version even though the OS is x64.  When starting the SQL installer it automatically chose the x64 version to match the OS.  No matter what I did it would not find my x86 version of SQL Express already installed.  I found lots of other people on the Internet with the same issue but it looks like most people just gave up and installed SQL over again.

I knew there had to be a way and after messing with the SQL installer I found it.  Buried in the Options of the SQL installer is a way to choose your processor type. 

Image

Changed it to x86, started the installer over again and bam instantly recognized the Express version installed.  5 minutes later I was happy camper.  Hopefully this help out someone else that was having the same issue!

Advertisements
Categories: SQL Tags:
  1. jadoo
    October 28, 2013 at 8:36 pm

    worked exactly same,thanks

  2. Ounnas
    February 13, 2014 at 10:47 am

    Thanks for your post. It helped me today 🙂 and worked fine from me.

  3. Lisa Ohrum
    March 5, 2014 at 10:29 am

    Thank you so much. I can’t believe how much garbage is out here on this topic and THIS IS THE ANSWER I was searching for.

    • March 5, 2014 at 11:03 am

      Hi Lisa,

      Glad I could help. When I first searched about the problem I had the same thoughts as you. I could not believe the amount of mis-information there was about this simple problem.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: