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) / Only User with Adminis...
Microsoft Dynamics CRM (Archived)

Only User with Administrator Role able to run Report

(0) ShareShare
ReportReport
Posted on by Community Member

I have been deploy SSRS Report in CRM 2016. Other user's trying to run the reports from CRM. But they all get error message (rsaccessdenied). All the users are the member of Reporting Group. Also has permission in the security role against report. 

I have tried this following article, but no luck:

http://techasp.blogspot.co.id/2013/06/how-to-fix-reporting-services.html

So far, we have found the answer. The user needs to be a Local Administrator in the computer (server) that sql server installed. After adding the users as Administrator on the Computer Server. They can run the reports. 

But, i think its strange that only local administator who can run the reports. Is it normal ? or did i make a mistake during setup the reporting server ? 

*This post is locked for comments

I have the same question (0)
  • David Jennaway Profile Picture
    David Jennaway 14,065 on at

    This sounds like a problem with your setup. The reporting services log files should give you more information on the issue. Does the issue apply for SQL-based reports, or Fetch-based reports, or both ?

  • Community Member Profile Picture
    Community Member on at

    Did you check the Administration tab in the report wizard and switch it from User to Organization? Also check actions/sharing, maybe you can do it there too?

  • Community Member Profile Picture
    Community Member on at

    @David Jennaway: we only tried with SQL-based report

  • Community Member Profile Picture
    Community Member on at

    @maxxsir: yes i did, i already change from User to Organization during importing the rdl file

  • Suggested answer
    Nithya Gopinath Profile Picture
    Nithya Gopinath 17,078 on at

    Hi Fikri,

    Do you have Read Privilege of entities that are queried by the report?

    See: community.dynamics.com/.../198201

  • Community Member Profile Picture
    Community Member on at

    @Nithya: Yes, the users have read privilege on that entities

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans