SQL Server 2005 Service Pack 2 (SP2) is required for running SQL Server components on Windows Server 2008.

Before installing Reporting Services, you must enable ASP.NET and IIS. To enable these features, configure a server role:

1. Click Start.
   
2. Click Server Manager at the top of the Start menu.
   
3. Right-click Roles, and select Add Roles.
   
4. On the Select Server Roles page, click Web Server (IIS). Selecting the Web Server role also selects File Server as role dependency. Click Next.
   
5. In the Role Services page, keep all the items that are selected by default, and then add the following additional items:
   
   1. In Common HTTP Features, select all the items in this section.
      
   2. In Application Development, select ASP.NET. You will be prompted to enable dependent services. Click OK to add the required role services.
      
   3. In Security, select Windows Authentication.
      
   4. In Management Tools, in IIS 6 Management Capability, select all the items.
      
6. Click Next, and then click Install.
   

If any of these features are not enabled, Setup will exclude Reporting Services from the Components to Select 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.

Note:

If you are upgrading both the report server instance and the operating system, and the report server instance is SQL Server 2005 Express Edition with Advanced Services, you must run Setup with SKUUPGRADE=1. For more information, see How to: Upgrade a SQL Server Express Report Server to Another SQL Server Edition. Note that there are known issues with edition upgrades. Check the SP2 readme for more information.

1. Log on to Windows Server 2008 and enable ASP.NET and IIS features as described in the Prerequisites 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, see 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. For instructions on how to install Reporting Services, see Reporting Services Installation How-to Topics.
     
   • 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.
     For best results on Windows Server 2008 Beta 3, choose the Install the default configuration option. If you cannot choose this option, you must choose the Install but do not configure the server option. Note that if you do are installing the SQL Server 2005 Express Edition with Advanced Services, you will encounter configuration errors when you configure the software after Setup is finished. For tips on how to troubleshoot these errors, see the Troubleshooting Installation Problems at the end of this topic.
     

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 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, select Run as administrator, type iisreset, and press ENTER.

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. Set the application pool for Report Manager and the Report Server Web service to ReportServer or Classic .NET AppPool:

   1. Open the Web Service Identity page.
      
   2. Select the ReportServer application pool.
      
   3. Click Apply.
      

   You cannot use Default Application Pool with Reporting Services. Reporting Services runs as a legacy application on IIS 7.0 and requires that you use an application pool that has Managed Pipeline Mode set to Classic. Avoid running the Report Server Web service under the default application pool on IIS 7.0. You will encounter HTTP 500 errors if you try to use it.

   Note that in the Beta 3 version of Windows Server 2008, if you are using custom application pool settings, you cannot configure the Report Manager application pool to run under a domain user account.

   If you installed the default configuration, no other configuration changes are required. If you are configuring a files-only installation, you must configure virtual directories and create the report server database. For instructions on how to configure these and other settings, see Reporting Services Configuration How-to Topics.

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 if you are using SQL Server Express with Advanced Services, http://<servername>/reports$sqlexpress).

3. Add http://<servername> to the Local Intranet security zone:

   1. Click Tools.
      
   2. Click Internet Options.
      
   3. Click Security.
      
   4. Click Local Intranet.
      
   5. Click Sites.
      
   6. 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.
      
   7. Click OK.
      

4. Create role assignments that grant permissions for local administration:

   1. In Report Manager, on the Home page, click Properties.
      
   2. Click New Role Assignment.
      
   3. Type a Windows user account in this format: <domain>\<user>.
      
   4. Select Content Manager.
      
   5. Click OK.
      
   6. Click Site Settings in the upper corner of the Home page.
      
   7. Click Configure Site-wide security.
      
   8. Click New Role Assignment.
      
   9. Type a Windows user account in this format: <domain>\<user>.
      
   10. Select System Administrator.
       
   11. Click OK.
       

5. Close Report Manager.

6. Re-open Report Manager in Internet Explorer, without using Run as administrator. You should have full access to all Report Manager features, including the Site Settings menu at the top of the page.

Tasks

Reference

Concepts

Other Resources

Help and Information