dynamics CRM reporting service, datasource error

Question

Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'DataSource1'. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: Caller S-1-5-21-885481334-3674160762-197611188-1617 has insufficient privilege to run report as user 77bc79a3-8d2e-e911-8100-00155d64ff3a

i followed the example to render/download a report, but got some error message .
https://learn.microsoft.com/en-us/dotnet/api/reportexecution2005.reportexecutionservice.render?view=sqlserver-2016

what i did more than sample is, set the credentials before render
rs.SetExecutionCredentials(dataSourceCredentials);

the credentials is user id and organization id

my question is which user/what permission needed to connection datasource1 - Microsoft Dynamics CRM Fetch

• rs.Credentials
• rs.SetExecutionCredentials
• reporting service system account

Answer 1

update:
in the sample, rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
i set the Credentials like rs.Credentials = new System.Net.NetworkCredential(UserName, PassWord);

UserName should be SSRS System Account, but at the beginning i set the admin user who installed the crm/ssrs/sql

Answer 2

Hi anonymous user ，

If you want to know Microsoft Dynamics CRM Fetch related question
Please refer to this thread to search for an answer ：https://community.dynamics.com/crm/f/microsoft-dynamics-crm-forum/228343/ssrs-fetch-xml-report-fails

Best Regards,
Isabella

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.