Skip to main content

Posts

Showing posts from April, 2014

How to create new (missing) columns for entities in your Data Export Service Azure SQL database

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.