How to: Install 32-bit Reporting Services on a 64-bit Computer

SQL Server 2005 Reporting Services provides native 64-bit support for server components on Itanium and x64 platforms, and client tool support on the x64 platform. However, some editions are available only in 32-bit versions. If you are using either SQL Server 2005 Express Edition with Advanced Services or SQL Server 2005 Workgroup Edition, you must perform the tasks described in this topic to install 32-bit Reporting Services on a 64-bit computer. The 32-bit versions of Reporting Services run in the WOW64 subsystem of the operating system.

Tasks

  • Uninstall any 64-bit report server instances that are on the same computer. On a 64-bit computer, you cannot run 64-bit and 32-bit instances of Reporting Services. If you have an existing 64-bit Reporting Services installation, run Setup to uninstall it.
  • If you are using IIS 6.0, install the 64-bit version of the .NET Framework 2.0 redistributable package.
  • Enable the 32-bit version of ASP.NET using a script provided in this topic. If you do not enable 32-bit ASP.NET, the Express Edition or Workgroup Edition of Reporting Services will not be available in the Components to Install page and you will see the following warning on the Prerequisite Check page of the Installation Wizard: “ASP.NET Verification Registration”. If you view the details for that warning, you will see the following message: “64-bit ASP .Net is Registered. Required 32-bit ASP .Net to install Microsoft Reporting Service 2005 (32.bit)”.
  • Install 32-bit Reporting Services after you run the script.

The following instructions explain how to install 32-bit Reporting Services on 64-bit versions of Windows Server 2003 and IIS 6.0, and Windows Vista and IIS 7.0.

To install 32-bit Reporting Services on 64-bit IIS 6.0

  1. If necessary, uninstall the 64-bit version of Reporting Services. Side-by-side deployment of 64-bit and 32-bit versions is not supported.

  2. Run dotnetfx64.exe to install the Microsoft .NET Framework manually. You can find this file in the Redist folder on the SQL Server 2005 Setup media, or you can download it from Microsoft .NET Framework Version 2.0 Redistributable Package (x64) on the Microsoft download site.

  3. In IIS Manager, click the Web Server Extensions folder.

  4. In the Details pane, right-click ASP.NET V2.0.50727, and then click Allowed.

  5. Right-click the Web Sites folder and then select Properties.

  6. Click ISAPI Filters.

  7. In Filter Name, select ASP.NET_2.0.50727, and then click Edit.

  8. Replace "C:\WINDOWS\Microsoft.NET\Framework64\v2.0.50727\aspnet_filter.dll" with the 32-bit version that is located in the Framework folder: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_filter.dll.

  9. Click OK. Save your changes, and close IIS Manager.

  10. Open a command prompt window, and then 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, click the Web Server Extensions folder.

  13. In the Details pane, right-click ASP.NET V2.0.50727 (32-bit), and then click Allowed.

To install 32-bit Reporting Services on 64-bit IIS 7.0

  1. If necessary, uninstall the 64-bit version of Reporting Services. Side-by-side deployment of 64-bit and 32-bit versions is not supported.

  2. Enable ASP.NET and IIS before installing Reporting Services. For instructions, see the Prerequisites section in How to: Install 32-bit Reporting Services on Windows Vista.

  3. Copy the following script:

    cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1
    
  4. Open a command prompt window. Point to Start, click All Programs, click Accessories, right-click Command prompt, select Run as administrator.

  5. Click Continue.

  6. In the command prompt window, in the top left corner of the window, right-click the command prompt icon, point to Edit, and select Paste.

  7. Press Enter to run the script.

  8. Install the 32-bit version of Reporting Services. You must apply SP2 to a Reporting Services installation on Windows Vista. If you are installing SQL Server 2005 Express Edition with Advanced Services, you can run a Setup program that already includes SP2. For more information, go to Microsoft SQL Server 2005 Express Edition with Advanced Services Service Pack 2 on the Microsoft Web site. If you receive errors during Setup, see the troubleshooting section at the end of this topic for further instruction.

  9. Reset IIS.

  10. Configure the report server for local administration. To access the report server and Report Manager locally, do the following:

    1. Open Internet Explorer.
    2. Type the default report server URL (https://localhost/reportserver) or Report Manager URL (https://localhost/reports).
    3. Click Tools.
    4. Click Internet Options.
    5. Click Security.
    6. Click Trusted Sites.
    7. Click Sites.
    8. Add http://<servername>.
    9. If you are not using HTTPS for the default site, clear the check box Require server certification (https:) for all sites in this zone.
    10. Click OK.
    11. Repeat the same steps for https://localhost. This allows you to open a browser window to either localhost or the NETBIOS name of the server for both the report server and Report Manager applications.
  11. Create role assignments that explicitly grant you access with full permissions:

    1. Open a browser window with Run as administrator permissions. Point to Start, click All Programs, right-click Internet Explorer, and select Run as administrator.
    2. Start Report Manager. By default, the Report Manager URL is http://<servername>/reports (or http://<servername>/reports$sqlexpress if you are using SQL Server Express with Advanced Services).
    3. On the Home page, click Properties.
    4. Click New Role Assignment.
    5. Type a Windows user account in this format: <domain>\<user>.
    6. Select Content Manager.
    7. Click OK.
    8. Click Site Settings in the upper corner of the Home page.
    9. Click Configure site-wide security.
    10. Click New Role Assignment.
    11. Type a Windows user account in this format: <domain>\<user>.
    12. Select System Administrator.
    13. Click OK.
    14. Close Report Manager.
  12. Reopen Report Manager in Internet Explorer, without using Run as administrator.

To troubleshoot Setup errors on Windows Vista

  • If you encounter setup failure error messages for SQL Server Native Client (SNAC), Database Services and Reporting Services, the SNAC installation package might be invalid or improperly installed. To work around this error, see Error message when you install SQL Server 2005 Express Edition Service Pack 2 Community Technology Preview on the Microsoft Web site.

  • If the previous steps do not resolve the errors, do the following:

    1. Cancel Setup.
    2. Click Start, click Control Panel.
    3. In Programs, click Uninstall a program.
    4. Select Microsoft SQL Server Native Client.
    5. Click Uninstall.
    6. Click Yes to continue.
    7. Extract the Express Edition installation package to a folder on your computer. On the installation media, run SQLEXPR_ADV.EXE /x.
    8. Choose a folder to extract the files.
    9. In the folder, find the SNAC installation package for SNAC (sqlncli_x64.msi).
    10. Double-click sqlncli_x64.msi and run the Setup program.
    11. Select SQL Server Native Client SDK, click Next, and then click Install.
    12. Click Continue.
    13. Re-try Setup for Express Edition with Advanced Services.
    14. Reset IIS.
    15. Follow the instructions starting at step 9 in the previous section.

See Also

Tasks

How to: Install 64-bit Reporting Services on Windows Vista
How to: Install 32-bit Reporting Services on Windows Vista

Concepts

Installing Reporting Services on 64-bit Computers
Considerations for Running SQL Server 2005 on Windows Vista

Other Resources

Reporting Services Installation How-to Topics

Help and Information

Getting SQL Server 2005 Assistance