Article ID: 948069 - View products that this article applies to.
When you try to run reports from the Operations console in Microsoft System Center Operations Manager 2007, you receive the following error message:
Note By default, the name of the reporting database that is installed is "OperationsManagerDW." The name of the database may differ depending on the name that is provided during reporting installation.
Cannot open Database "OperationsManagerDW" requested by the login. The login failed. Login failed for user 'UserAccount'
This problem occurs when the Root Management Server (RMS) is installed on clustered servers, and the SDK account that is used on each cluster node is different.
Consider the following scenario:
To work around this problem, use the same domain account as the SDK account on all nodes of the RMS cluster during the RMS cluster nodes setup. However, you may have to use different SDK accounts on each node of the cluster. In this case, give access to all the SDK accounts that are used to the OperationsManagerDW database after you install the SCOM reporting service.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.