Reporting Services 2005 installation option is grayed out

Reporting Services 2005 installation option is grayed out

  • Comments 5

 

Consider a scenario when during the installation of SQL Reporting Services 2005 the option to choose Reporting Services is grayed out.

The following warning displayed in SCC check

32-bit ASP.Net is Registered. Required 64-bit ASP.Net to install Microsoft Reporting Services 2005

Case 1

If one is installing a 32 bit (WOW) version of Reporting services on 64bit version of IIS and the ASP.NET registration is 64 bit.

Case 2

If one is installing a 64 bit version of SQL Reporting Services on a 64 bit version of IIS which is running in 32 bit mode and the ASP.NET registration is 32 bit.

Case 3

When one is installing a 32 bit version of SQL Reporting Services 2005 on a 64 bit version of windows 2008 Server or when one is installing a 64 bit version of SQL Reporting Services 2005 on a 64 bit version of windows 2008 Server and IIS is running in 32 bit.

Reason

While performing the SCC check we query the IIS metadatabase to verify the bitness of ASP.Net Registration. If the ASP.NET registration does match our installation type i.e. 32 or 64 bit, we throw this warning.

Resolution

Case 1 and 2

One needs to reconfigure IIS to run under 32 or 64 bit as per the installation of Reporting services (32 or 64). We also need to reregister ASP.NET 2.0 with 32 or 64 bit version respectively.

The steps involved to do this are well documented in the KB article http://support.microsoft.com/kb/894435

Case 3

One needs to reconfigure IIS & to run under the respective 32 bit or 64 bit mode as per the Reporting services setup requirement.

To reconfigure IIS 7 need to follow the steps below

1) Open IIS Manager (Start -> Administrative ->Tools Internet Information services (IIS) Manager)

2) Expand the server on the left pane

3) Click on Application Pools

4) On the right pane under Actions click on Set Application Pool Defaults

5) In Application Pool Defaults window under General click on Enable 32-Bit Applications

6) Set this option to True or False depending upon the scenario (If the option is TRUE then IIS is running in 32 bit mode)

7) Reset IIS from the command prompt

8) Rerun the SQL installation

Feroz R
SE, Microsoft Sql Server

Reviewed By

Rakesh Singh
Technical Lead, Microsoft Sql Server

 

Leave a Comment
  • Please add 3 and 7 and type the answer here:
  • Post
  • PingBack from http://microsoft-sharepoint.simplynetdev.com/reporting-services-2005-installation-option-is-grayed-out/

  • Thank you so much for this clear fix! :)

  • Thanks for useful tips & tricks :D

  • IF YOU ARE INSTALLING REPORTING SERVICES 2008 FROM SQL 2008 64 bit Edition on a WINDOWS 2008 SERVER x64 BIT EDITION

    ===================================================================================================================

    I have come across an instance of (having installed both the IIS and II6 Management Consoles) that an attempted installation of Reporting Services part of the 64 bit installation of SQL Server 2008 on a Windows 2008 x64 system will still be greyed / grayed out.  I found a workaround by performing the following tasks:

    1. Ensure that Set Application Pool defaults has the Enable 32 bit applications set to False

    2. In the Command Prompt, navigate to the %SystemRoot%\Microsoft.NET\Framework64\v2.0.50727\ folder and run the aspnet_regiis -i command.

    3. In the Command Prompt, navigate to the %SystemRoot%\Microsoft.NET\Framework\v2.0.50727\ folder and run the aspnet_regiis -u command.

    4. Perform iisreset /noforce at the command

    5. Rerun Setup for SQL Server 2008 x64.  Reporting Services is available for installation.

    If you are doing the opposite (i.e. installing the 32 bit version of SQL Server 2008 on a Windows 2008 Server x64 edition, use the -u switch in step 2 and -i in step 3 instead....

    Happy Days!

  • In a recent comment I posted out by mistake I mentioned SQL 2008 / Reporting Services 2008.  I was referring to installing SQL 2005 x64 bit edition on a Windows 2008 x64bit machine.  My mistake.  Please amend accordingly.  Thank you.

Page 1 of 1 (5 items)