dynamics CRM reporting service, datasource error

Justin Jia 306 Reputation points

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 .

what i did more than sample is, set the credentials before render

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,362 questions
{count} votes

Accepted answer
  1. Justin Jia 306 Reputation points

    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,606 Reputation points

    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,

    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.