How to install SQL Server 2008 x64 and SQL Server 2008 Reporting services X86 side by side on Windows 2008 X64


Symptoms


Consider the following scenario:

You run a Windows 2008 server that is running x64 version of SQL Server 2008 database engine component. 

In this scenario, if you try to install x86 version of the SQL Server 2008  Reporting services component by using 'Add features to existing instance of SQL Server 2008', the setup program will report the following error message in the Installation Rules page.

 

Rule

Status

Same architecture installation

Failed

 If you click on the 'Failed' status you will see the following message:

Rule "same architecture installation" failed.
The CPU architecture of installing feature(s) is different than the instance specified. To continue, add features to this instance with the same architecture.

 

Cause


The behavior is by design.  When you chose the option to add features to the existing instance the 'Same architecture installation' rule checks whether the features that are being added are of the same CPU architecture as existing features for that instance, and if they are not,  it blocks the installation. In other words you cannot install a 64 bit version of one component (like Database engine) and a 32 bit version of another component (like Reporting services) for the same instance of SQL server.

 

Resolution


Use the following procedure to install 32 bit edition of Reporting services component:

  1. Launch SQL Server Installation Center by running setup.exe from the installation media.
  2. In the Options section, select the 'Processor type' as x86.
  3. In the Installation section select 'New SQL Server Stand alone installation or add features to an existing installation'.
  4. On the 'Installation Type' screen during the setup process, select 'Perform a new instance of SQL Server 2008' and continue with the setup to do a 'Files-only' installation of reporting services instance and configure the same at a later stage using Reporting services Configuration manager.