This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 12%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
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
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
SQL 2008R2 is installed with 64 bit version and also I am trying to upgrade this instance using 64 bit SQL 2014 version only.
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
Yes, its of 64 bit version
Version Details:
Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) Jun 28 2012 08:36:30
Copyright (c) Microsoft Corporation
Developer Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)
Yes, its of 64 bit version
Version Details: Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) Jun 28 2012 08:36:30 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)
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.
I think SQL Server 2008 R2 SP2 or later will support SQL 2014.
As the application is not supporting any higher versions and hence we are proceeding with SQL 2014 as of now. We will upgrade it to latest versions(SQL 2019 or SQL 2022) later once Application is upgraded.
Application? Application supports? Please, you are not talking about a production environment, are you? In such case, you have a lot bigger problem than what version of SQL Server you are using...