Deploying MOM Reporting on a SQL Server Cluster

  • Article

Deploying MOM Reporting and the Reporting Database on a SQL Server cluster is very similar to deploying the MOM database on a SQL Server cluster. This section details the differences between these processes and provides the information you need to deploy them successfully. You can install the MOM Reporting Database on only one SQL Server node at a time. The steps for installing it on the first node are slightly different than the steps for installing it on subsequent nodes.

Deployment Overview

You must do a full installation on the first node and then a partial installation on the subsequent nodes. You can install MOM Reporting only on an active node; each node that you want to install it on must be made active before you install. During subsequent node installations, you must select the Passive node of a Windows Server Cluster check box to signify that the node will be configured as a passive node.

Verifying That the Server Is the Active Node

Follow the instructions under "Installing the MOM Database on an Active/Passive Cluster" section of this document.

Installing the MOM Reporting Database Component

Run the MOMReporting.msi file or MOM Setup to install the MOM Reporting component on the cluster node.

Providing the MOM Service Accounts

After you provide a name for the instance of SQL Server that will host the MOM Reporting Database, you are asked for information about the DAS account. Provide the account information for the service account that you created before you started MOM Setup.

Adding Login Information

After you install the MOM Reporting and Reporting database components, you must add login information to the active node so that the MOM Reporting components can have access to the clustered MOM database. To do this, run the following TSQL statement on the active cluster node.

Use SystemCenterReporting
execute p_SetupLogins '<ComputerName for the MOM Reporting Node>'

Verifying the MOM Local Group Creation

As part of the installation process, MOM Setup automatically creates local groups on the cluster node. Verify that the following groups exist on the local system:

  • SC DW DTS

  • SC DW Reader

Note

When you install MOM Reporting, MOM Setup also creates the SC DW DTS group on the MOM database server.

Verifying the Reporting Database Installation

After you log on to the MOM cluster node with an account that has local administrator rights, verify the existence of the following:

  • SystemCenterDTSPackageTask under Scheduled Tasks.

  • SystemCenterReporting database in SQL Server Enterprise Manager.

Validating the Location of Database and Log Files

In the Database and Log File Size dialog box, verify that the database and database log files are placed in the %Program Files%\Microsoft SQL Server\MSSQL\Data directory. The database file is RepData.mdf, and the log file is RepLog.ldf.

Disabling Redundant DTS Tasks

When you install the MOM Reporting components on a cluster, MOM Setup creates a copy of the SystemCenterDTSPackageTask DTS job for each cluster node. You must disable or delete all but one of these jobs. You can do this by going to Scheduled Tasks.