asked on

SCOM 2007 R2 - loads of Event id 1107 health service errors

Hi Guys,

I have been getting loads of errors in my RMS event logs relating to health service 1107. This is driving me mad as I can't make them stop. examples below. I have read some posts about associating the data warehouse sql server authentication account profile with an account, but this was never set up from the start, we just used the default action account. I believe these errors started when we migrated the RMS to another Hyper-v host.

Account for RunAs profile in workflow "Microsoft.SystemCenter.DataWarehouse.CollectEventData", running for instance "scomserver.local" with id:"{21AD8213-7D40-47A4-A684-292134249746}" is not defined. Workflow will not be loaded. Please associate an account with the profile. Management group "opsmgr"

Account for RunAs profile in workflow "Microsoft.SystemCenter.DataWarehouse.CollectPerformanceData", running for instance "scomserver.local" with id:"{21AD8213-7D40-47A4-A684-292134249746}" is not defined. Workflow will not be loaded. Please associate an account with the profile. Management group "OpsMgr"

if anyone else has solved a similar issue please help!.

Regards

MikeVR6

mikevr6

ASKER

Ok I created a 2 accounts with simple authentication with blank a space for username and passwords for "data warehouse sql server authentication" and SDK sql server authentication" as I found on another forum, not I am getting different error messages, event ID 31557:

Failed to obtain synchronization process state information from Data Warehouse database. The operation will be retried.
Exception 'SqlException': Management Group with id '3210E437-C4ED-8FF4-B00A-BCCEE79AB879' is not allowed to access Data Warehouse under login 'domain\username'

One or more workflows were affected by this.

Workflow name: Microsoft.SystemCenter.DataWarehouse.Synchronization.MaintenanceMode
Instance name: scomserver.local
Instance ID: {21AD8213-7D40-47A4-A684-292134249746}
Management group: opsmgr

ASKER CERTIFIED SOLUTION

Maekee

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial