Problem Viewing QOE and CDR Reports

In our internal environment randomly the Monitoring and CDR Reports randomly stopped working. After some troubleshooting and help from Google translator: http://blogs.technet.com/stefan/archive/2009/07/07/probl-me-de-visualisation-des-rapports-cdr-qoe.aspx

We were able to verify that the RTCReportPack account did not have “Allow Log on Locally” on the SQL Server.

After clicking to generate a report we would see this error:

 

  • An error has occurred during report processing. (rsProcessingAborted)
  • Cannot impersonate user for data source ‘CDRDB. (rsErrorImpersonatingUser)
  • Logon failed. (rsLogonFailed)
  • For more information about this error navigate to the report server on the local server machine, or enable remote errors.
  •  

    After adding the RTCReportPack account to the Allow Logon Locally group in the local security policy this went away.

    Advertisements

    About Randy Wintle

    Unified Communications Architect

    Posted on August 3, 2009, in Microsoft, OCS, OCS 2007 R2, Unified Communications. Bookmark the permalink. Leave a comment.

    Leave a Reply

    Fill in your details below or click an icon to log in:

    WordPress.com Logo

    You are commenting using your WordPress.com account. Log Out /  Change )

    Google photo

    You are commenting using your Google account. Log Out /  Change )

    Twitter picture

    You are commenting using your Twitter account. Log Out /  Change )

    Facebook photo

    You are commenting using your Facebook account. Log Out /  Change )

    Connecting to %s

    %d bloggers like this: