Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM forum
Unanswered

Invalid User Authorization while running CRM reports

Posted on by Microsoft Employee

While trying to run the reports in CRM (on-peemise) , we are getting "Invalid User Authorization"

For reference ,please check the log file error message below:-

"Invalid User Authentication. The user authentication passed to the platform is not valid". There is error "Microsoft.Crm.CrmException: The current organization id could not be determined" 

Note: User is a part of both Priv User group and Sql Access group

Looking for the positive response as early as possible.

Invalid-User-Authorization.png

Categories:
  • Alan Ericson Profile Picture
    Alan Ericson on at
    RE: Invalid User Authorization while running CRM reports

    I have encountered this error in the past and it was due to port 808 being blocked on the CRM Web front end server.

    I would suggest to run a platform trace on the CRM Web front end when attempting the report and review for related errors.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Invalid User Authorization while running CRM reports

    Thank you for your response.

    User is a part of PrivReportingGroup and PrivUserGroup.

    We tried run the cmd (gpupdate/force) in sql server  however the issue still persist.

  • Daniel Schneider Profile Picture
    Daniel Schneider 168 on at
    RE: Invalid User Authorization while running CRM reports

    I looked at the group son my ad and saw the reporting service user is added to PrivReportingGroup and PrivUserGroup.

    On the sql Server try on cmd grpupdate /force

    Hope this helps

  • Daniel Schneider Profile Picture
    Daniel Schneider 168 on at
    RE: Invalid User Authorization while running CRM reports

    Is the user who try to use report the service user for reporting service? Please open SQL Reporting Configuration with the Report Service User and try test the connection to the DB by changing the Database. Please only test the connection and dont change the db. If test is failed you need to add the user to administrator group on to the local sql machine. I had the same issue and add the user to the group on sql machine and directly in sql as new connection.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Invalid User Authorization while running CRM reports

    Thank you for your response

    As i have already mentioned in the description ,  User is been added in  both the groups

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Invalid User Authorization while running CRM reports

    Thank you for your response..

    As i had already mentioned in  the description , User is added in both the mentioned groups.

  • Daniel Schneider Profile Picture
    Daniel Schneider 168 on at
    RE: Invalid User Authorization while running CRM reports

    Try to add the user who is runnig the report to the groups in the ad

    PrivUserGroup and SQLAccessGroup.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Invalid User Authorization while running CRM reports

    Thank you for your quick feedback

    Yes it is happening for both OOB and custom reports. Also we we are not able to run the reports from  SSRS  and we havent found any traces in CRM Platform Trace.

  • edmunch Profile Picture
    edmunch on at
    RE: Invalid User Authorization while running CRM reports

    Is this happening with both OOB reports and custom ones?  Can you run these reports directly from SSRS?  What does it show in the CRM Platform traces?

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans