web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / MS CRM 2011 report err...
Microsoft Dynamics CRM (Archived)

MS CRM 2011 report error while run it from CRM

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

I am facing below error in one of our deployment while running a report from MS CRM 2011:

"An error has occurred during report processing. (rsProcessignAborted) cannot create a connection to data source 'CRM' (rsErrorOpeningConnection) Immediate caller NT AUOTHORITY/SYSTEM has insufficient privilege to run the report as user."

Database server & report server are on the different and reporting service is running with local system.

Can anyone help me in this. ?

Thanks & Regards,

Neelam

*This post is locked for comments

I have the same question (0)
  • Bruno Lucas Profile Picture
    Bruno Lucas 5,421 on at

    Hi,
    it could be a few different causes. is this a fresh deployment? did you run some rollup upgrade?
    few ways I fixed similar problem

    scenario 1: SQL server reboot\recycle alone. you may need to either restart the application server or recycle the async and other services related to the CRM application server

    scenario 2: changes on the account that runs CRM application server IIS application pool.

    scenario 3: problem with crm ssrs adapter, need to be reinstalled\upgraded with proper rollup

    and many others, check this list:
    http://blog.simpletrees.com/2013/04/mscrm-and-dreaded-rsprocessingaborted.html

  • betlejuice Profile Picture
    betlejuice 2,139 on at

    Hi Neelam!  you need to give that user or a group a privilege to run report

    Try to do this:

    1. Open localhost/reports

    2. Go to properties tab (SSRS 2008)

    3. Security->New Role Assignment

    4. Add DOMAIN/USERNAME or DOMAIN/USERGROUP

    5. Check Report builder

  • Community Member Profile Picture
    Community Member on at

    Hi Neelam,

    Please verify that Reporting Services Configuration Manager -> Execution Account user is added to the below groups.

    -PrivReportingGroup

    -ReportingGroup

    -SqlAccessGroup

    -PrivUserGroup

    Regards,

    Saad

  • Suggested answer
    Satish Tiwari - CRM Profile Picture
    Satish Tiwari - CRM on at

    Hi Neelam,

    I would suggest to add CRM and SQL Server in PrivUserGroup and PrivReportingGroup and then try to run reports. If its still fails then run same report from Report Server and let me know the exact error.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans