dynamics CRM reporting service, datasource error

贾海锋 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,949 questions
{count} votes

Accepted answer
  1. 贾海锋 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
  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.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.