2,397
Hi, I am trying to view crm reports from report server, but I always got the error like the below, I am using service account, is there anything I've missed?
*This post is locked for comments
Hello,
When running a report directly from the Report Server you need to provide a different set of credentials that Dynamics uses internally to authenticate against your report.
In SQL server, run this query against the organization DB to get those GUIDs:
SELECT TOP 1 SystemUserId, OrganizationId FROM SystemUserBase WHERE InternalEmailAddress = 'name@company.com';
Hope this helps you get started. If you have any other questions, please let me know!
If you found my answer helpful, please help the community by marking it as verified :-)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (