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

New: 15 September 2007

This topic explains the requirements and steps for installing Reporting Services on Windows Vista. For instructions on how to upgrade a Windows XP computer that has a Reporting Services installation, see How to: Upgrade Reporting Services on Windows Vista. If you are using a 64-bit computer, see How to: Install 32-bit Reporting Services on a 64-bit Computer and Installing Reporting Services on 64-bit Computers.

  • You must have the Windows Vista Enterprise Edition, Ultimate Edition, or Business Edition.
  • You can install any of the following SQL Server 2005 editions: Developer Edition, Standard Edition, Workgroup Edition, Evaluation Edition, or the Express Edition with Advanced Services. Enterprise Edition is not supported on Windows Vista.
  • You must apply Service Pack 2 (SP2) to the Reporting Services installation. For most editions, you must install the original product release first and then upgrade to SP2. If you are using Express Edition with Advanced Services, you can run a Setup program that already has SP2 applied. For more information, see Microsoft SQL Server 2005 Express Edition with Advanced Services Service Pack 2 on the Microsoft Web site.
  • Before installing Reporting Services, you must enable ASP.NET and IIS. To enable these features, do the following:
    1. Click Start.
    2. Click Control Panel.
    3. Click Programs.
    4. Click Programs and Features, and then click Turn Windows features on or off. Wait for the feature list to appear.
    5. Open Internet Information Services.
    6. In Web Management Tools, enable the following features:
      IIS 6 WMI Compatibility
      IIS Metabase and IIS 6 configuration compatibility
    7. In World Wide Web Services, in Application Development, enable the following features:
      ISAPI Extension
      ISAPI Filters
    8. In Common HTTP Features, enable the following features:
      Default Document
      Directory Browsing
      HTTP Errors
      HTTP Redirection
      Static Content
    9. In Security, enable the following feature:
      Windows Authentication

If any of these features are not enabled, Setup will exclude Reporting Services from the Feature Selection page.

After you enable the required features, you must start the World Wide Publishing Service if you want to install the default configuration of Reporting Services. Otherwise, you must install Reporting Services in files-only mode and configure the report server after SQL Server Setup is finished.

  1. Log on to Windows Vista and enable ASP.NET and IIS features as described in the requirements section.

  2. Verify that the World Wide Web Publishing service is started. If it is not started, configure it for Automatic startup:

    1. Click Start.
    2. Click Control Panel.
    3. Click System and Maintenance.
    4. Click Administrative Tools. You might have to scroll down the panel until you see it.
    5. Double-click Services.
    6. Click Continue.
    7. Right-click World Wide Web Publishing, and select Properties.
    8. In Startup Type, click Automatic.
    9. Click Apply.
    10. Click Start.
    11. Click OK to close the window.
  3. Install SQL Server 2005 Reporting Services:

    • If you are installing SQL Server 2005 Express Edition with Advanced Services, install SP2. To download SP2, go to Microsoft SQL Server 2005 Express Edition with Advanced Services Service Pack 2 on the Microsoft Web site.
    • For all other editions, you must install the original product release. The Program Compatibility Assistant will warn you that the current release is not compatible. Click Run Program to continue installation.
    • The Installation Wizard includes the Report Server Installation Options page. On this page, you can select the default configuration or install program files and configure the server later. If both options are available, you can select either one. In contrast with some upgrade scenarios, SP2 will be installed correctly over a files-only install when you are using new installation of Windows Vista.
    • For instructions on how to install Reporting Services, see Reporting Services Installation How-to Topics.
  4. Apply SP2.

    • To download SP2, see How to obtain the latest SQL Server 2005 Service Pack on the Microsoft Web site. If you installed the SP2 version of the Express Edition with Advanced Services, you can skip this step because SP2 is already applied.
    • During SP2 setup, you can stop services in order to avoid a system restart. To stop the services, open Control Panel, click Administrative Tools, double-click Services, right-click the service, and click Stop.
    • Do not stop services prior to running setup. The service must be running in order to perform an authentication check.
    • If the Provisioning Tool opens, start the services before you use it. You can use the tool to easily add Windows user accounts to the SYSADMIN fixed server role.
  5. Start the services if you have not done so already. If you are installing the Express Edition with Advanced Services, reset IIS. To reset IIS, click Start, click All Programs, click Accessories, right-click Command Prompt, type iisreset, and press Enter.

  6. If you chose the files-only installation option, configure the report server:

    1. Start the Reporting Services Configuration tool. To open the tool, click Start, click All Programs, click SQL Server 2005, click Configuration Tools, and then click Reporting Services Configuration.
    2. Click Continue.
    3. In the Instance Selection dialog box, select the report server instance and then click Connect.
    4. Configure the server for operation. For instructions, Reporting Services Configuration How-to Topics.

    Important   Reporting Services runs as a legacy application on IIS 7.0. If you are configuring the application pool for the report server virtual directory on a new Reporting Services installation, choose Classic .NET AppPool or create a new application pool that has Managed Pipeline Mode set to Classic. If you installed Reporting Services in the default configuration, the report server will run in its own application pool under the NetworkService account. The default configuration results in a fully operational report server on Windows Vista. Avoid running the Report Server Web service under the default application pool on IIS 7.0. You will encounter HTTP 500 errors if you attempt to use it.

  7. 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 (http://<servername>/reportserver) or Report Manager URL (http://<servername>/reports).
    3. Click Tools.
    4. Click Internet Options.
    5. Click Security.
    6. Click Trusted Sites.
    7. Click Sites.
    8. Add http://<servername>. If you are not using HTTPS for the default site, clear the check box Require server certification (https:) for all sites in this zone.
    9. Click OK.
  8. 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.
  9. Re-open Report Manager in Internet Explorer, without using Run as administrator.

If you installed Business Intelligence Development Studio on Windows Vista, you will encounter compatibility issues with the Visual Studio 2005 environment when you use the design tools.

If you want to open an existing project or solution, or publish items from Report Designer or Model Designer to a report server, you must open Business Intelligence Development Studio with elevated permissions:

  1. Click the Start button, click All Programs, click SQL Server 2005, right-click Business Intelligence Development Studio, and then click Run as administrator.
  2. Click Continue.
  3. Click Run Program.

You should now be able to deploy reports and other items to a report server. If you do not have sufficient permissions, you will encounter issues such as the following:

  • Access Denied errors when you try to open an existing project.
  • Login failure errors when you configure a data source connection to a shared data source.
  • When using the Report Server Wizard to create a report, you will get a login failure error when the Wizard attempts to connect to the external data source that provides data to the report.

SQL Server Management Studio users must use Run as administrator permissions to create logins for users who administer databases on the server. For more information about elevated permission requirements for Management Studio, see How to: Connect to SQL Server from Windows Vista.

Community Additions