How to install a 32-bit version of SQL Server 2005 Reporting Services on a computer that is running a 64-bit version of Windows

Reporting Services provides native 64-bit support for the following:

• Server components on Itanium-based versions of Windows and on 64-bit versions of Windows.
• Client tools on 64-bit versions of Windows.

However, the following editions of SQL Server 2005 that include Reporting Services are available only in 32-bit versions:

• SQL Server 2005 Express Edition with Advanced Services
• SQL Server 2005 Workgroup Edition

If you use one of these editions of SQL Server 2005 on a computer that is running a 64-bit version of Windows, follow these steps to install the 32-bit version of Reporting Services:

1. Uninstall the 64-bit version of Reporting Services.
   
   
   Note Side-by-side installations of 32-bit versions of Reporting Services and 64-bit versions of Reporting Services in the Microsoft Windows-32-on-Windows-64 (WOW64) subsystem are not supported.
2. Install the 64-bit version of the Microsoft .NET Framework 2.0 redistributable package.
3. Enable the 32-bit version of Microsoft ASP.NET on the computer.
   
   Note You can run the script in this article to enable the 32-bit version of ASP.NET. If you do not enable the 32-bit version of ASP.NET before you install SQL Server 2005 Express Edition with Advanced Services or SQL Server 2005 Workgroup Edition, Reporting Services will not be available on the
   Components to Install page. Additionally, you will receive a warning message for the ASP.NET Version Registration Requirement item on the System Configuration Check page. If you view the report for this warning message, you receive one of the following error messages:
   
   • In Windows Server 2008, you receive the following error message:
     64-bit ASP.Net is Registered. Required 32-bit ASP.Net to install Microsoft Reporting Service 2005 (32.bit).
   • In Windows Server 2003, you receive the following error message:
     Failed to find ASP.Net Version Registration with Microsoft Internet Information Services (IIS)
4. Install the 32-bit version of Reporting Services after you run the script.

The following sections provide information about how to install the 32-bit version of Reporting Services on a computer that is running the 64-bit version of Microsoft Internet Information Services (IIS) 6.0 and on a computer that is running the 64-bit version of IIS 7.0. The 64-bit version of Windows Server 2003 contains the 64-bit version of IIS 6.0. The 64-bit version of Windows Vista contains the 64-bit version of IIS 7.0.

Install the 32-bit version of Reporting Services on a computer that is running the 64-bit version of IIS 6.0

To install the 32-bit version of Reporting Services on a computer that is running the 64-bit version of IIS 6.0, follow these steps:

1. Uninstall the 64-bit version of Reporting Services.
   
   Note Side-by-side installations of 32-bit versions of Reporting Services and 64-bit versions of Reporting Services are not supported.
2. Run the Dotnetfx64.exe file to manually install the .NET Framework.
   
   The Dotnetfx64.exe file is in the Tools\redist\2.0 folder on the SQL Server 2005 Setup media. To download the Dotnetfx64.exe file, visit the following Microsoft Web site:
   http://go.microsoft.com/fwlink/?LinkId=70186
3. In IIS Manager, click Web Server Extensions.
4. In the Details pane, right-click ASP.NET V2.0.50727, and then click Allow.
5. Right-click Web Sites, and then click
   Properties.
6. Click the ISAPI Filters tab.
7. In the Filter Name column, click
   ASP.NET_2.0.50727, and then click Edit.
   
8. Replace C:\WINDOWS\Microsoft.NET\Framework64\v2.0.50727\aspnet_filter.dll with C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_filter.dll.
   Note The Aspnet_filter.dll file in the C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\ folder is a 32-bit version of the file.
9. Click OK two times, and then close IIS Manager.
10. At a command prompt, run the following command:
    cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1
11. Install the 32-bit version of Reporting Services.
12. After setup is complete, open IIS Manager, and then click
    Web Server Extensions.
13. In the Details pane, right-click ASP.NET V2.0.50727 (32-bit), and then click Allow.

Install the 32-bit version of Reporting Services on a computer that is running the 64-bit version of IIS 7.0

To install the 32-bit version of Reporting Services on a computer that is running the 64-bit version of IIS 7.0, follow these steps:

1. Enable ASP.NET and IIS before you install Reporting Services.
2. Open a command prompt. To do this, click
   Start, point to All Programs, point to
   Accessories, right-click Command Prompt, and then click Run as administrator.
3. In the User Account Control dialog box, click Continue.
4. Set the Enable32bitAppOnWin64 option to True at the Parent level under the master Web site level. To do this, follow these steps:
   1. In IIS Manager, click Application Pools.
   2. In the Actions pane, click Set Application Pool Defaults.
   3. In the General section, set the Enable32bitAppOnWin64 option to True.
   NoteBy default, a SQL Server 2005 64-bit installer will look for a 64-bit IIS installation. If the Enable32bitAppOnWin64 option is set to False at the root level, then the installation of Reporting Services should complete successfully.
5. Install the 32-bit version of Reporting Services. You must apply SQL Server 2005 Service Pack 2 (SP2) after you install Reporting Services in Windows Vista. If you install SQL Server 2005 Express Edition with Advanced Services, you can run SQL Server 2005 Express Edition with Advanced Services SP2.
   
   For more information, visit the following Microsoft Web site:
   http://go.microsoft.com/fwlink/?LinkID=63922
   If errors occur during setup, see the "Troubleshoot setup errors on Windows Vista" section.
6. Reset IIS.
7. Configure the report server for local administration. To access the report server and Report Manager locally, follow these steps:
   
   1. Start Microsoft Internet Explorer.
   2. On the Tools menu, click
      Internet Options.
   3. Click Security.
   4. Click Trusted Sites.
   5. Click Sites.
   6. Under Add this website to the zone, type
      http://servername.
      
   7. If you are not using HTTPS for the default site, click to clear the Require server certification (https:) for all sites in this zone check box.
   8. Click Add.
   9. Repeat steps f and g to add http://localhost, and then click Close.
      
      This step lets you start Internet Explorer either to localhost or to the network computer name of the server for both Report Server and Report Manager.
8. Create role assignments that explicitly grant you full-permissions access. To do this, follow these steps:
   
   1. Start Internet Explorer by using the Run as administrator option. To do this, click Start, click
      All Programs, right-click Internet Explorer, and then click Run as administrator.
   2. Start Report Manager.
      
      Note By default, the Report Manager URL is http://servername/reports. If you are using SQL Server 2005 Express Edition with Advanced Services SP2, the Report Manager URL is http://servername/reports$sqlexpress. If you are using a named instance of Reporting Services, the Report Manager URL is http://servername/reports$InstanceName.
   3. On the Home page, click
      Properties.
   4. Click New Role Assignment.
   5. Type a Windows user account in the following format:
      domain\user
   6. Click to select the Content Manager check box.
   7. Click OK.
   8. In the upper-right corner of the Home page, click Site Settings.
   9. Click Configure site-wide security.
      
   10. Click New Role Assignment.
   11. Type a Windows user account in the following format:
       domain\user
   12. Click to select the System Administrator check box.
   13. Click OK.
   14. Close Report Manager.
9. Open Report Manager in Internet Explorer without using the Run as administrator option.

Troubleshoot setup errors on Windows Vista

If you encounter "setup failure" error messages for SQL Server Native Client (SNAC), for Database Services, and for Reporting Services. Or, the SNAC installation package might be invalid or incorrectly installed.
For more information, click the following article number to view the article in the Microsoft Knowledge Base:

929667 Error message when you install SQL Server 2005 Express Edition Service Pack 2 Community Technology Preview: "An installation package for the product Microsoft SQL Server Native Client cannot be found"

If the steps to install the 32-bit version of Reporting Services do not resolve the errors, follow these steps:

1. Exit the Setup program.
2. Click Start, and then click
   Control Panel.
3. Click
   Uninstall a program.
4. Click Microsoft SQL Server Native Client.
   
5. Click Uninstall.
6. Click Yes.
7. Extract the SQL Server 2005 Express Edition with Advanced Services installation package to a folder on your computer. To do this, run
   SQLEXPR_ADV.EXE /x at a command prompt.
8. Select a folder into which to extract the files.
9. In the folder, find the Sqlncli_x64.msi file. This is the SNAC installation package for SNAC.
10. Double-click the Sqlncli_x64.msi file, and then run the Setup program.
11. On the Feature Selection page, click
    SQL Server Native Client SDK, click This feature will be installed on local hard drive, click Next, and then click Install.
12. In the User Account Control dialog box, click Continue.
13. Install SQL Server 2005 Express Edition with Advanced Services.
14. Reset IIS.
15. Repeat steps 9 through 11 in the "Install the 32-bit version of Reporting Services on a computer that is running the 64-bit version of IIS 7.0" section.

Additional information

In IIS 7.0, the Enable32bitapponwin64 option can be set to various levels at the Web site level in addition to at the specific site level. This was not the case with IIS 6.0. You can either run IIS 6.0 in Complete 32-bit mode or in 64-bit mode, but not both.

A 32-bit SQL Server 2005 installer looks for a 32-bit IIS installation. This is because a 32-bit SQL Server 2005 installer requires IIS to run in 32-bit mode. This is not true in an IIS 7.0 scenario because IIS 7.0 can run in different modes or bitness at different levels. For example, IIS 7.0 can run a specific Web site in 32-bit mode and another Web site in 64-bit mode. This new feature was introduced in IIS 7.0.

For more information, visit the following Microsoft Web sites:


32-bit Mode Worker ProcessesEnable32BitAppOnWin64 Metabase Property (IIS 6.0)