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 :
Microsoft Dynamics CRM (Archived)

SSRS returning Invalid user authorization from CRM

(0) ShareShare
ReportReport
Posted on by 121

Hi, i just develop a SSRS report for my CRM Organization. This Report run well when i run from my browser. But when other system administrator user trying to run this report. It's returning Invalid user authorization. I have make sure that this report has deployed as organization report. So i think everyone should be able to run this report.  

What i have tried are :

1. In the datasource of the report. There are 4 type of credentials option. And only Windows Authentication is worked for my report. When i chose other option, the report will showed a blank page, not a report page.

324633.1.png

2. If i register the other user as SQL Server Administrator, the report can work. But this can't be solution since the report should be viewable by regular user. Not system administrator user.

3. I just curious with reporting server, so i trying to access reporting service configuration manager. However, it's strange that there is no reporting service instance available in my server. Im sure there are reporting service instace during the installation of CRM .

4428.2.png

Anyone faced the same issue and know how to fix it ? Any suggestion would be appreciate.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Radu Chiribelea Profile Picture
    6,667 on at

    Hello,

    Can you please check if you have the SPNs properly registered ? See blogs.msdn.microsoft.com/.../configuring-service-principal-names

    Regards,

    Radu

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)

#1
ScottDurow Profile Picture

ScottDurow 2

#2
GJones Profile Picture

GJones 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans