CRM2016 On Premisis
For some reason I am getting the dreaded rsProcessingAborted messag when trying to run a specific report. other reports run fine
I went back to basics, created a blank report in my VS project. Added an Image and uploaded it to CRM on the invoice entity. So far so good.
In Reports , I can run the report and it is displayed ok.
If I open an invoice and run the report I get the rsprocessing aborted
(part of report server log below )
The CRM is running on network/service
SQL Reporting Server running on network/service
the log is showing an error Select permission was denied
crypto!ReportServer_0-1!170c!01/11/2018-19:04:18:: i INFO: Initializing crypto as user: NT AUTHORITY\NETWORK SERVICE
crypto!ReportServer_0-1!170c!01/11/2018-19:04:18:: i INFO: Exporting public key
crypto!ReportServer_0-1!170c!01/11/2018-19:04:18:: i INFO: Importing existing encryption key
library!ReportServer_0-1!170c!01/11/2018-19:04:26:: i INFO: Entering StreamRequestHandler.ExecuteCommand - Command = Render
library!ReportServer_0-1!170c!01/11/2018-19:04:27:: i INFO: RenderForNewSession('/Operations_MSCRM/CustomReports/{c39e7eda-2bf2-e711-8461-00155d011b1f}')
processing!ReportServer_0-1!170c!01/11/2018-19:04:33:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'InvoiceHeader'. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException:
System.Data.SqlClient.SqlException: The SELECT permission was denied on the object 'Account', database 'Operations_MSCRM', schema 'dbo'. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: The SELECT permission was denied on the object 'Account', database 'Operations_MSCRM', schema 'dbo'.
--- End of inner exception stack trace ---
at Microsoft.Crm.Reporting.DataExtension.Common.ExceptionManager.HandleUnsafeException[TResult](Func`1 body)
at Microsoft.Crm.Reporting.DataExtensionShim.Common.ICrmDbCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Crm.Reporting.DataExtensionShim.Common.SrsExtCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.OnDemandProcessing.RuntimeLiveQueryExecutor.ExecuteReader(IJobContext jobContext, DataSourceErrorInspector errorInspector, String commandText)
