How to fix upgrade architecture mismatch error in SQL 2008R2

Rushikumar Kuntumalla 20 Reputation points
2023-06-05T04:39:16.6733333+00:00

Hello Team,

I'm trying to upgrade a SQL Server 2008 x64 Developer install to a 2014 x64 Developer Install. It got failed while checking the rules and throwing this error --"Upgrade Architecture mismatch" failed.

Error Message from details.txt:
Slp: Initializing rule : Upgrade architecture mismatch

Slp: Rule is will be executed : True

Slp: Init rule target object: Microsoft.SqlServer.Configuration.SetupExtension.BlockMixedArchitecture

Slp: Rule 'BlockMixedArchitectureUpgrade' detection result: IsMixedArchitectureInstall= True

Slp: Evaluating rule : BlockMixedArchitectureUpgrade

Slp: Rule running on machine:

Slp: Rule evaluation done : Failed

Slp: Rule evaluation message: The CPU architectures of upgrading feature(s) and this installation program are different. To upgrade these features, Setup architecture must be the same as the features being installed.

Slp: Send result to channel : RulesEngineNotificationChannel

I thought like it was due to different versions(32-bit & 64 bit) versions installed but on checking on checking I haven't found any 32 bit versions installed on the control panel?

Is there anyway to find what are all the versions which was installed with 32-bit?

Also please guide me on how to fix this?

Regards

Rushikumar

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,699 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. CosmogHong-MSFT 22,861 Reputation points Microsoft Vendor
    2023-06-05T07:14:39.86+00:00

    Hi @Rushikumar Kuntumalla

    First, check the version of SQL Server 2008 installed and 2014 you download. You could find it in the detail.txt.

    And then make sure you select right instance in the upgrade dialog.

    Could you please post the Detail.txt file?

    Best regards,

    Cosmog Hong

  2. Olaf Helper 40,741 Reputation points
    2023-06-05T10:46:38.0366667+00:00

    I'm trying to upgrade a SQL Server 2008 x64 Developer install

    Sure it's a x64 and not a x86 SQL Server? In 2008 it wasn't very common to have x64 = 64 bit. Run this query and post the result.

    select @@version
  3. Erland Sommarskog 100.9K Reputation points MVP
    2023-06-05T21:29:41.2666667+00:00

    I note that you are on SQL 2008 R2 SP2. I have not checked, but most likely you need to apply Service Pack 3 before you can upgrade to SQL 2014.

    Although, if you don't have SP3 around, it can be difficult to find is SQL 2008 R2 is out of all support. You may have to install a new instance and migrate all databases through BACKUP/RESTORE.

    Also, why SQL 2014? This is also a version that is quite dusty. Why not a more modern version like SQL 2022.