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 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.
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.
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
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.
Thank you for your response
As i have already mentioned in the description , User is been added in both the groups
Thank you for your response..
As i had already mentioned in the description , User is added in both the mentioned groups.
Try to add the user who is runnig the report to the groups in the ad
PrivUserGroup and SQLAccessGroup.
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.
#1
Daivat Vartak (v-9d...
225
Super User 2025 Season 1
#2
Muhammad Shahzad Sh...
106
#3
Vahid Ghafarpour
82
Super User 2025 Season 1
Share
Report
All responses (
Answers (
