12

I have a test environment set up with the following:

  • Virtual Machine (Hyper-V)
  • Windows Server 2008 R2 SP1(x64-bit)
  • Windows SQL Server 2005 Developer Edition SP4 (x64-bit)(default instance name)
    • 1 Database with Merge Replication set up... 3 publications with 2 subscribers each.

We are testing the procedure for upgrading to SQL Server 2012 Developer Edition (sp1)...

I have downloaded the iso for 64bit SQL Server 2012 Dev. (sp1) from MSDN (full licensed copy) and have started going down the upgrade path. At one of the final stages, where it begins a check for different criteria, we run into a bizarre issue as outlined below:

Rule "Upgrade architecture mismatch" failed. The CPU architectures of upgrading feature(s) are different. To upgrade these features, Setup architecture must be the same as the features being installed.

Furthermore, in the upgrade log file, I found the following (more verbose) output:

(03) 2012-12-28 14:02:45 Slp: Init rule target object: Microsoft.SqlServer.Configuration.SetupExtension.BlockMixedArchitecture
(03) 2012-12-28 14:02:45 Slp: Rule 'BlockMixedArchitectureUpgrade' detection result: IsMixedArchitectureInstall= True 
(03) 2012-12-28 14:02:45 Slp: Evaluating rule        : BlockMixedArchitectureUpgrade
(03) 2012-12-28 14:02:45 Slp: Rule running on machine: REPLICATIONTEST
(03) 2012-12-28 14:02:45 Slp: Rule evaluation done   : Failed
(03) 2012-12-28 14:02:45 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.

I have made sure that we are on an x64 system and not an ia64 and I see no reason why a mismatch would be occurring. Something to note: We cannot simply install SQL Server 2012, and reattach the databases to it as we have over 20 live databases (in production) with over 40 publications set up... this would be an absolute nightmare if we had to re-set up replication.

Here is the version info for the SQL Server 2005 setup:

Microsoft SQL Server 2005 - 9.00.5000.00 (X64) 
Dec 10 2010 10:38:40 
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1)

9.00.5000.00 indicated SP4.

I will be calling Microsoft support about this tomorrow.

Improve this question
14
  • 1
    Can you verify the edition you downloaded? Is it possible you downloaded the Standard edition of SQL 2012, and not the Developer edition?
    – SQLRockstar
    Commented Dec 28, 2012 at 22:47
  • I mentioned it in my post but I did download SQL Server 2012 Developer Edition (x64) SP1.
    – Wes
    Commented Dec 28, 2012 at 22:48
  • 1
    Can you run "select @@version" on the current instance and post the entire output.
    – mrdenny
    Commented Dec 28, 2012 at 22:51
  • 2
    The amount of MVP and MCMs responding to this is outstanding! Looks like someone on the MSDN forums ran into the same issue: social.msdn.microsoft.com/Forums/en/sqlsetupandupgrade/thread/…
    – Ali Razeghi - AWS
    Commented Dec 28, 2012 at 23:22
  • 2
    Could either tools (SSMS etc) or SSIS have been installed separately to the main install as 32bit?
    – Mark Storey-Smith
    Commented Dec 31, 2012 at 11:23

1 Answer 1

Reset to default
6
+100

Could either tools (SSMS etc) or SSIS have been installed separately to the main install as 32bit?

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.