Export (0) Print
Expand All

Installing the software prerequisites on the reporting server for a five-server topology

Published: December 16, 2009

Applies To: Forefront Client Security

The reporting server has the following prerequisites:

  • IIS and ASP.NET

  • .NET Framework 2.0

  • SQL Server 2005 with SP2 or SP1

Before installing the prerequisites, verify that the server meets the hardware and operating system requirements and that you have installed all critical computer and security updates. As part of the updates, make sure that you have Windows Update Agent 2.0 or later. Windows Update Agent automatically updates itself to the latest version when you download updates from Microsoft.

In addition, you must do the following:

  • Configure Reporting Services and create the remote database.

  • Add the reporting server site to the Local intranet zone in Internet Explorer.

Install IIS and ASP.NET

To install IIS and ASP.NET
  1. Click Start, point to Administrative Tools, and then click Manage Your Server.

  2. In the Manage Your Server window, click Add or Remove a Role.

  3. In the Configure Your Server wizard, click Next.

  4. On the next page, click Application Server (IIS, ASP.NET), and then click Next.

  5. On the next page, select the ASP.NET check box, and then complete the wizard.

Install .NET Framework 2.0

To install .NET Framework 2.0
  • In many cases, .NET Framework 2.0 is already installed. If it's not installed, install it from the Microsoft Download Center (http://go.microsoft.com/fwlink/?LinkId=77420).

Install SQL Server 2005 with SP2 or SP1

Because this is the reporting server and not the reporting database server, you should install only Reporting Services on this server. Later, you will configure Reporting Services and create the remote database on the reporting database server.

About installing SQL Server 2005 on the reporting server
  • For information about installing SQL Server 2005, see SQL Server 2005 Books Online (http://go.microsoft.com/fwlink/?LinkId=77422).

  • When installing SQL Server 2005, you must do the following:

    • Install only Reporting Services. (On the Components to Install page, select the Reporting Services check box.)

    • Install Reporting Services without configuring it. You will configure it in the following procedures. (On the Report Server Installation Options page, make sure that the Install but do not configure the server check box is selected.)

    • Have the SQL Server Agent service start automatically. (On the Service Account page, under Start services at the end of setup, select the SQL Server Agent check box.)

  • If you plan to use a secure connection for reports in Client Security, you should set up the SSL configuration while you are installing SQL Server. For more information, see SQL Server 2005 — Reporting Services at Microsoft TechNet (http://go.microsoft.com/fwlink/?LinkId=84767).

  • When installing SQL Server 2005, you should use Windows Authentication as the security mode. Windows Authentication mode is much more secure than mixed mode. (On the Authentication Mode page, select Windows Authentication Mode.)

To install SP2 or SP1 for SQL Server 2005
  • Do one of the following:

    • Download and install SP2 for SQL Server 2005 from the Microsoft Download Center (http://go.microsoft.com/fwlink/?LinkID=84823).

    • Download and install SP1 for SQL Server 2005 from the Microsoft Download Center (http://go.microsoft.com/fwlink/?LinkId=77417).

Configure the report server and create the remote database

Because Reporting Services and the reporting database are not on the same server, your installation of SQL Server on the reporting server requires additional configuration. As part of that configuration, you must create the reporting database on the remote server.

To configure the report server and create the remote database
  1. On the reporting server, click Start, point to All Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Surface Area Configuration.

  2. On the SQL Server 2005 Surface Area Configuration page, click Surface Area Configuration for Services and Connections.

  3. In the Surface Area Configuration for Services and Connections dialog box, select Service under the Reporting Services component, and then verify that it is running. Click OK.

  4. Click Surface Area Configuration for Features.

  5. In the Surface Area Configuration for Features dialog box, select Scheduled Events and Report Delivery under the Reporting Services component, and then verify that it is enabled.

  6. Select Web Service and HTTP Access under the Reporting Services component, and then verify that it is enabled.

    noteNote:
    Because you have not yet configured Reporting Services, you cannot verify that Windows Integrated Security is enabled.

  7. Click OK, and then close the SQL Server 2005 Surface Area Configuration page.

  8. Click Start, point to All Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click Reporting Services Configuration.

  9. Select the current server in the Machine Name box, and then click Connect.

  10. On the Report Services Configuration page, click Report Server Virtual Directory.

  11. Next to the Name box, click New.

  12. In Create a New Virtual Directory, ensure that the Web site is Default Web Site, verify the default value ReportServer is entered, and then click OK.

  13. Click Report Manager Virtual Directory.

  14. Next to the Name box, click New.

  15. In Create a New Virtual Directory, make sure the Web site is Default Web Site, verify the default value Reports is entered, and then click OK.

  16. Click Web Service Identity.

  17. In the Report Server and the Report Manager boxes, configure the following:

    For Windows Server 2003, select DefaultAppPool, and then click Apply.

    For Windows Server 2008, select Report Server or Classic .Net AppPool, and then click Apply.

  18. Click Database Setup.

  19. In the Server Name box, enter the reporting database server, and then click Connect. You must have permission to create a database and configure roles on that server. The Reporting Services Configuration tool will use your credentials to create the database.

    ImportantImportant:
    For this step to succeed, you may need to disable the firewall on the reporting database server.

  20. In the SQL Server Connection dialog box, click OK. Do not change the Credentials Type.

  21. Next to Database Name, click New.

  22. In the SQL Server Connection dialog box, keep the default values. Click OK.

  23. In the Credentials Type box, select Windows Credentials. This is required for this version of Client Security.

  24. In the Account Name and Password boxes, enter the domain user account that you want to use as the service account.

  25. Click Apply.

  26. In the SQL Server Connection dialog box, click OK. Do not change the Credentials Type.

  27. Configure other settings as needed, and then verify the installation. For more information, see How to: Verify a Reporting Services Installation (http://go.microsoft.com/fwlink/?LinkId=85560).

Add the reporting server site to the Local intranet zone in Internet Explorer

For SQL Server Reporting Services to function correctly, you must add the reporting server site to the Local intranet zone on the reporting server itself.

noteNote:
Internet Explorer maintains two different lists of sites for the Local intranet zone. One list is in effect when the enhanced security configuration is enabled, and a separate list is in effect when the enhanced security configuration is disabled. When you add a Web page to the Local intranet zone, you are adding it only to the list that is currently in effect.

To add the reporting server site to the Local intranet zone in Internet Explorer
  1. In Internet Explorer, on the Tools menu, click Internet Options.

  2. Click the Security tab, and then click the Local intranet zone.

  3. Click the Sites button.

  4. Click the Advanced button.

  5. In the Add this website to the zone box, type the URL of the SQL Server Reporting Services site (for example, http://servername).

  6. Click Add.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft