I have installed the SQL Reporting Service on a different server from the CRM server (Dynamics CRM 2011 Server) but when I run the reports, it is giving me the following error:
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset 'DSMain'. (rsErrorExecutingCommand)
And it the SSRS log, I see the error:
library!ReportServer_0-1!2518!03/02/2015-15:57:36:: w WARN: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
Cannot create a connection to data source 'CRM'. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException:
System.FormatException: Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx). ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).
We never had this issue when we installed the SSRS on the same server as the CRM server. Is there anything I need to do to make it work?