I finally found a fix for the problems that I’ve experienced with the DNS Management Pack in Operations Manager 2007; actually it’s more of a work-around: add the Data Reader account to the Operations Manager Administrators group and all is well. Note that this should be the group designated during installation as the Operations Manager Administrators; the setup program adds this group to the Operations Manager Administrators role.
The problem occurs when the DNS Management Pack is added to Ops Manager 07 and generates the following alert: Data Warehouse failed to deploy reports for a management pack to SQL Reporting Services Server. Additionally, an error is logged in the Operations Manager event log (a sample of which is copied below).
I’ve experienced this problem both in the lab and in multiple production environments. This problem does not affect any other management packs and I have no idea what it is uniquely doing to cause this issue. I do think it’s an installation only issue and if you remove the account from that group after the MP has been successfully deployed to all agents, everything will work fine – I haven’t actually tested taking it back out though.
Event Type: Error
Event Source: OpsMgr SDK Service
Event Category: None
Event ID: 26319
Date: 12/20/2007
Time: 2:50:34 PM
User: N/A
Computer: MOM
Description:
An exception was thrown while processing GetRelationshipTypesByCriteria for session id uuid:2856e71b-a9a4-4518-ba41-151504c5e7d1;id=19.
Exception Message: The creator of this fault did not specify a Reason.
Full Exception: System.ServiceModel.FaultException`1[Microsoft.EnterpriseManagement.Common.UnauthorizedAccessMonitoringException]: The creator of this fault did not specify a Reason. (Fault Detail is equal to Microsoft.EnterpriseManagement.Common.UnauthorizedAccessMonitoringException: The user DOMAIN\scomreader does not have sufficient permission to perform the operation.).
March 12, 2008 at 8:48 pm
[...] the culprit is the DNS management pack, the fix on ihaveablog didn’t work for me though. Removing the DNS management pack [...]