Reporting Services 2005 installation option is grayed out


 


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




 


Comments (5)

  1. Matt says:

    Thank you so much for this clear fix! :)

  2. Eser says:

    Thanks for useful tips & tricks 😀

  3. Jon Lahaye says:

    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.NETFramework64v2.0.50727 folder and run the aspnet_regiis -i command.

    3. In the Command Prompt, navigate to the %SystemRoot%Microsoft.NETFrameworkv2.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!

  4. Jon Lahaye says:

    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.