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

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 (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.

Back to the top

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.
   Note By 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 (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.

Back to the top

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 (http://support.microsoft.com/kb/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.