In this procedure, you will install the Microsoft SQL Server 2005 databases services, management tools, and integration services. You will configure the SQL Server Services to run as the OMAdmin domain account and the Authentication Mode will be Windows Authentication.


  1. Install SQL Server 2005 on OMSQL01

Install SQL Server 2005 on OMSQL01

Procedure W03-DWM.11: To install SQL Server 2005 on OMSQL01

  1. On OMSQL01, on the SQL Server 2005 installation media, double-click Setup.exe to start the SQL Server 2005 installation.

  2. Follow the on-screen instructions to perform the installation. Use mainly the defaults and ensure the following:

    • On the Components to Install page, select the SQL Server Database Services, the Reporting Services, the Integration Services, and the Workstation components, Books Online and development tools options.
    • On the Service Account page, select Using a Domain User Account, and then specify fabrikam\OMAdmin account.
    • Under Start services at the end of setup, ensure that SQL Server and SQL Server Agent are selected.
  3. Complete the SQL Server 2005 installation by applying SQL Server 2005 SP2, Reporting Services, Workstation and tools.

  4. Confirm the existence of the ReportServer and ReportServerTempDB databases in SQL Server Management Studio.

  5. Confirm the correct configuration of Reporting Services by opening Internet Explorer and browsing to http://OMSQL01/reports.

For detailed installation instructions, see the System Center Operations Manager 2007 Deployment Guide (available at the Systems Center Operations Manager 2007 Documentation).