Operations Manager 2007 R2 Installation and Configuration (Step by Step) – Part 6 “Installing Data Warehouse Database”

In this post series I went through step by step into System Center Operations Manager 2007 R2 starting from “Pre-Build”, then I continued with “Installing Operations Manager Database”, followed by another post “Installing Root Management Server”, then “Configure GPO for SCOM”, lately followed by “Configuring SQL Reporting Service”,

In this post I will cover the installation of Data Warehouse Database that is store all Data for Operations Manager Reporting.

Steps are as the following:

Step	Description	Screenshot
	SQL 2008 Reporting Service should be installed and configured before starting Operations Manager 2007 R2 Reporting installation, Use local administrator privileges to log on to SQL Server. This account must also have system administrator privileges on the instance of SQL Server that will host the Operations Manager 2007 R2 Reporting database
1.	Launch SetupOM.exe from installation folder. Click Pre-requisites under Prepare. Select data warehouse and confirm it passes all pre-requisite tests. Then click Close. Under Install click Install Operations Manager 2007 R2 Reporting.
2.	On the Welcome page, Click Next
3.	On the End-User License Agreement page, accept the agreement and then click Next.
4.	On the Product Registration page, provide the User and Organization names and Click Next
5.	On the Custom Setup page, Select Data Warehouse and Reposting Server as Available locally and Click Next.
6.	On the Connect to the Root Management Server page, provide the RMS name (MIS_SCOM) and Click Next
7.	On the SQL Server database Instance page, Select the Instance from the dropdown list and enter the SQL Server Port (1433 is the default). Then Click Next
8.	On Database and Log File Options 1) Keep Database Name as default OperationsManagerDW. 2) Set the database size for example 200000 MB 3) Click Advanced.
9.	(Optional if need to move Database Warehouse to different drive and Logs in different drive as recommended, however if there is no enough resources as in Coca Cola Egypt case then use the available disk drives) Under Look in: Select U: drive and under Folder name type U:Data Click OK.
10.	On the SQL Server Reporting Services Instance, Select the Instance from the dropdown list and Click OK
11.	On the Data Warehouse Write Account page, Provide the DWHWrite credentials and Click Next This account was created before
12.	On the Data Reader Account page, Provide the DWHRead credentials and Click Next. This account was created before.
13.	On the Operational Data Reports page, Click No and then Click Next.
14.	On the Ready to Install the Program page, Click Install
15.	On the following page, Click Finish