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

  • Article

Applies To: Forefront Client Security

The reporting server has the following prerequisites:

  • IIS and ASP.NET

  • 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 versions when you download updates from Microsoft.

In addition, you must 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 SQL Server 2005 with SP2 or SP1

To use an existing installation of SQL Server, when running the Setup wizard, provide the server location. You still must use SQL Server 2005 with SP2 or SP1. In addition, the existing installation must not have a SystemCenterReporting database. (This is created for the reporting server as part of the Client Security installation.)

About installing SQL Server 2005 on the reporting server

  • For information about installing SQL Server 2005, see SQL Server 2005 Books Online (https://go.microsoft.com/fwlink/?LinkId=77422).

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

    • Install Database Services, Reporting Services, Integration Services, and Workstation components. (On the Components to Install page, select the following check boxes: SQL Server Database Services, Reporting Services, Integration Services, and Workstation components.)

    • Use a domain user or network service account for the SQL Server and SQL Server Agent service accounts. It is recommended that you use a domain user account. (On the Service Account page of the wizard, click Domain user account.)

    • 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.)

    • Use collation that is not case-sensitive. (On the Collation Settings page of the wizard, choose an option that is not case-sensitive.)

  • 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 (https://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

Change the location for data and log files

After installing SQL Server 2005, you can change the location for SQL Server data and log files.

To change the location for data and log files

  1. Open SQL Server Management Studio. (On the Start menu, click All Programs, click Microsoft SQL Server 2005, and then click SQL Server Management Studio.)

  2. In the Connect to Server dialog box, click Connect.

  3. Right-click the root server name node, and then click Properties.

  4. In the Server Properties dialog box, under Select a page, click Database Settings.

  5. In Database default locations, enter the locations you want to use for the data and log files, and then click OK.

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.

Note

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, https://servername).

  6. Click Add.