CRM 2013: ReportExecutionException: Immediate caller CRM2013\ssrs has insufficient privilege to run report as user
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'CRM'. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: Immediate caller CRM2013\ssrs has insufficient privilege to run report as user S-1-5-20. On a migrated CRM 2013 environment (coming from 4.0 to CRM 2011) I had the issue that reportings were not working. Problem was that in the old 4.0 version the SSRS service account did not have to be in the privuser group. With the new version I guess it is absolutely necessary to have this account also in the group privuser group as well as the privreporting group. Solution: Add the SSRS service account always to privuser and privreporting group.