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

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 Microsoft Employee 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
JS-09031509-0 Profile Picture

JS-09031509-0 3

#2
AS-17030037-0 Profile Picture

AS-17030037-0 2

#2
Mark Eckert Profile Picture

Mark Eckert 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans