Invalid User Authorization while running CRM reports

(0) Share

Report

Posted on by Community Member

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.

I have the same question (0)

All responses (9)

Answers (0)

edmunch on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Daniel Schneider 172 on at

Like (0)

Report

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

PrivUserGroup and SQLAccessGroup.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you for your response..

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you for your response

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

Was this reply helpful? Yes No
Daniel Schneider 172 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Daniel Schneider 172 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Alan Ericson on at

Like (0)

Report

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.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Invalid User Authorization while running CRM reports

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

Invalid User Authorization while running CRM reports

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates