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) / Error in SSRS Reports ...
Microsoft Dynamics CRM (Archived)

Error in SSRS Reports (rsAccessDenied)” (rsProcessingAborted)

(0) ShareShare
ReportReport
Posted on by Kishor Kumar 3,710

Hey Guys,

An Custom SSRS Reports working perfectly for all the other users, when an new user is added, he is not able view the reports getting an error like this.

"An error has occurred during report processing. (rsProcessingAborted)

Query execution failed for dataset 'DataSet2'. (rsErrorExecutingCommand)
For more information about this error navigate to the report server on the local server machine, or enable remo"

In site settings  of the SSRS  reports , I had given the Permission as System admin and user role also but still  getting an error as

“The permissions granted to user “Domain\User” are insufficient for performing this operation. (rsAccessDenied)”  

Need help thanks in advance

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Kishor Kumar Profile Picture
    Kishor Kumar 3,710 on at

    Guys got the solution it was issue with Priv and Reporting for the resceptive user

  • Mark_Edel Profile Picture
    Mark_Edel 160 on at

    Hi Kishor,

    May I know what was the root cause on this issue. We also encountered it. I also noticed that inbound ports such as BIservices and others were stopped. Do you have an idea what was the cause?

    Thanks and Regards,

    Mark

  • Kishor Kumar Profile Picture
    Kishor Kumar 3,710 on at

    Hi Mark,

    The Issue was, the user does not have the Priv and Reporting rights in the server so the issue. So when I give those above privileages and made an IIS Reset in the server the issue got solved.

    It was the reason for my case.

  • Samkh Profile Picture
    Samkh 6 on at

    Hi,

    Would you please clarify what you meant by  "the Priv and Reporting rights in the server ", what exactly have you changed and which server? I am having the same issue.

  • Kishor Kumar Profile Picture
    Kishor Kumar 3,710 on at

    Hi Sam,

    The user does not have the Priv and Reporting rights in the server(CRM installed Server) so the issue. So when I give those above privileages and made an IIS Reset in the server the issue got solved.

    It was the reason for my case.

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