Microsoft KB Archive/938439

= The Reporting DTS task does not run and reports do not work when Microsoft Operations Manager (MOM) 2005 fails over to the secondary node of a server cluster =

Article ID: 938439

Article Last Modified on 8/2/2007

-

APPLIES TO


 * Microsoft Operations Manager (MOM) 2005

-



SYMPTOMS
Consider the following scenario. You install Microsoft Operations Manager (MOM) 2005 on a server cluster. MOM 2005 fails over to the secondary node of the server cluster. In this scenario, the MOM 2005 Reporting Data Transformation Services (DTS) task no longer runs successfully. Therefore, MOM reports do not work when MOM 2005 runs on the secondary cluster node. If you fail back MOM 2005 to the primary cluster node, MOM 2005 works as expected.



CAUSE
When you install MOM 2005 on the secondary node of a server cluster, the MOM 2005 installation program does not add the user logon information to Microsoft SQL Server. Therefore, when MOM 2005 fails over to the secondary cluster node, the user account under which the DTS task runs cannot access the following databases:
 * The OnePoint database
 * The SystemCenterReporting database



WORKAROUND
To work around this problem, manually configure the appropriate MOM database rights for the secondary cluster node. To do this, follow these steps.

Note In these steps, the secondary cluster node is named Cluster2.  Fail over or move the group that contains the MOM 2005 resources to the secondary cluster node. For this article, fail over or move the group to Cluster2.  Start the SQL Server Management Studio program, and then run the following SQL Server statement: Use OnePoint Go execute p_SetupLogins 'example\momDAS','Cluster2',0 Note In this code,  represents the name of the Data Access Server (DAS) account in MOM 2005.   Run the following SQL Server statement: Use SystemCenterReporting Go execute p_SetupLogins 'Cluster2' 



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.



MORE INFORMATION
For more information about how to install the MOM database on a server cluster, visit the following Microsoft Web site:

http://www.microsoft.com/technet/prodtechnol/mom/mom2005/Library/172e3a0a-5381-4517-9060-1449ee92810e.mspx?mfr=true

Keywords: kbtshoot kbprb kbpending kbbug KB938439

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.