ReportProcessingException: Cannot create a connection to data source ‘CRM’
Recently, when we deployed our CRM managed solution with reports on our testing environment, we were getting “rsProcessingAborted” error while accessing the reports.
When we check the event viewer for more error details, we found below “Caller has insufficient privilege to run report” exception
Data source ‘CRM’: An error has occurred. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
Cannot create a connection to data source ‘CRM’. —> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: Caller has insufficient privilege to run report as user
Reason
- In our scenario, SQL Server report service was running under a separate “Service Account”
SSRS Report Service Account
- The service account under which report service was running does not have required privileges to establish connection and access filtered views
Below fix worked for us
Fix
- Since the Report Service’s “service account” was unable to access CRM filtered views,
- We added the “service account” as a member of the AD’s “PrivReportingGroup {Org_guid}” and “PrivUserGroup {Org_guid}” groups
- Provided “service account” SQL Server login with permissions to ReportServer and ReportServerTempDB (db_owner, RSExecRole)
Categories: CRM 2011, SSRS
connection to data source 'CRM', CRM 2011, reports, rsProcessing, SSRS
Rajeev Pentyala - Microsoft Power Platform 
Hi Rajeev,
I think that I have the same Problem; when i run the report for “activated Users” I become Reporting Error The report cannot be displayed. (rsProcessingAborted). Other reports like Quote works.
I have MS Crm 2013 on Windows 2012 with separate Sql-Server 2012.
The User running Reporting Services on Sql-Server is Member on the above mentioned groups on the AD. And the SQL-Server-Account too.
Perhaps can you help me?
Thanks
Kader