Installing the software prerequisites on the reporting database server for a three-server topology
Applies To: Forefront Client Security
The reporting database server has one prerequisite: SQL Server with SP2 or SP1.
Before installing the prerequisite, 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.
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 database server as part of the Client Security installation.)
Because this is the reporting database server and not the reporting server, you should install Database Services only on this server. Later, you will install Reporting Services on the management, collection, and reporting server.
About installing SQL Server 2005 on the reporting database server
When installing SQL Server 2005, you must do the following:
Install Database Services, Integration Services, and Workstation components. (On the Components to Install page, select the following check boxes: SQL Server Database 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 a collation that is not case-sensitive. (On the Collation Settings page of the wizard, choose an option that is not case-sensitive.)
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.)
During the SQL Server Setup wizard, the System Configuration Check displays a warning that IIS is required. You can ignore this warning. IIS is not required for the SQL Server installation on the reporting database.
To install SP2 or SP1 for SQL Server 2005
Do one of the following:
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
Open SQL Server Management Studio. (On the Start menu, click All Programs, click Microsoft SQL Server 2005, and then click SQL Server Management Studio.)
In the Connect to Server dialog box, click Connect.
Right-click the root server name node, and then click Properties.
In the Server Properties dialog box, under Select a page, click Database Settings.
In Database default locations, enter the locations you want to use for the data and log files, and then click OK.