dynamics CRM reporting service, datasource error

Justin Jia 306 Reputation points
2021-09-22T06:52:56.697+00:00

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
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,813 questions
Accepted answer
  1. Justin Jia 306 Reputation points
    2021-09-28T00:54:04.303+00:00

    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

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Isabellaz-1451 3,616 Reputation points
    2021-09-22T09:56:47.953+00:00

    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.