Wednesday, February 1, 2012

CRM 2011 Reports SSRS Error SetExecutionCredentials

If you are getting the error below running Reports, not to worry. Generally this is an easy fix. Find out what account Reporting Services is running under and add it to the Active Directory group PrivReportingGroup. If SRS is running as a LocalService or NetworkService (local accounts), you will need to add the SRS computer object to the AD group. After doing that, just restart the Reporting Services windows service and you should be good to go! Exception information: Exception type: CrmReportingException Exception message: An error occurred during report rendering. at Microsoft.Crm.Web.Reporting.SrsReportViewer.SetExecutionCredentials(ServerReport reportObj) at Microsoft.Crm.Web.Reporting.RemoteSrsReportViewer.LoadReportAndSetParameters() at Microsoft.Crm.Application.Controls.AppUIPage.OnPreRender(EventArgs e) at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) An error has occurred during report processing. (rsProcessingAborted) at Microsoft.Reporting.WebForms.ServerReportSoapProxy.OnSoapException(SoapException e) at Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.ProxyMethodInvocation.Execute[TReturn](RSExecutionConnection connection, ProxyMethod`1 initialMethod, ProxyMethod`1 retryMethod) at Microsoft.Reporting.WebForms.ServerReport.SetDataSourceCredentials(IEnumerable`1 credentials) at Microsoft.Crm.Web.Reporting.SrsReportViewer.SetExecutionCredentials(ServerReport reportObj) Cannot create a connection to data source 'CRM'. (rsErrorOpeningConnection)