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.
Tasks
- Install SQL Server 2005 on OMSQL01
Install SQL Server 2005 on
OMSQL01
Procedure W03-DWM.11: To install SQL Server 2005 on OMSQL01
-
On OMSQL01, on the SQL Server 2005 installation media, double-click Setup.exe to start the SQL Server 2005 installation.
-
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.
- 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.
-
Complete the SQL Server 2005 installation by applying SQL Server 2005 SP2, Reporting Services, Workstation and tools.
-
Confirm the existence of the ReportServer and ReportServerTempDB databases in SQL Server Management Studio.
-
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).