Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2021 Release Wave 1Discover the latest updates and new features to Dynamics 365 planned April 2021 through September 2021.
Release overview guides and videos Release Plan | Preview 2021 Release Wave 1 Timeline
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
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.
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?
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.
Try to add the user who is runnig the report to the groups in the ad
PrivUserGroup and SQLAccessGroup.
Thank you for your response..
As i had already mentioned in the description , User is added in both the mentioned groups.
Thank you for your response
As i have already mentioned in the description , User is been added in both the groups
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.
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
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 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.
Business Applications communities