How to install SQL 2005 Reporting services (SSRS) on 64bit OS

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 for the ASP.NET Version Registration Requirement item on the System Configuration Check page. If you view the report for this 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).
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 (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. Copy the following script:
   cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1
5. In the upper-left corner of the Command Prompt window, right-click the command prompt icon, click Edit, and then click Paste.
6. Press ENTER to run the script.
7. 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.
8. Reset IIS.
9. 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.
10. 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.
11. 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: 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.

For more information about how to install Reporting Services on a Windows Vista-based computer, click the following article number to view the article in the Microsoft Knowledge Base: For more information about how to upgrade Reporting Services on a Windows Vista-based computer, click the following article number to view the article in the Microsoft Knowledge Base: