we have setup on our QA env on:
SQL Reporting Services and the SQL databases are installed on the same server, CRM box is separate server. When we run the custom report that data are retrieving FetchXML,
which giving following error (CRM trace) but connection use on .net SQL provider is working perfectly.
at SrsReportViewer.ReportErrorHandler(Object sender, ReportErrorEventArgs e)
at ReportViewer.OnError(Exception e)
at ReportViewer.OnPreRender(EventArgs e)
at Control.PreRenderRecursiveInternal()
at Control.PreRenderRecursiveInternal()
at Control.PreRenderRecursiveInternal()
at Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at Page.ProcessRequest()
at Page.ProcessRequest(HttpContext context)
at CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
at ApplicationStepManager.ResumeSteps(Exception error)
at HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
at HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
at ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
>Crm Exception: Message: An error occurred during report rendering., ErrorCode: -2147187924, InnerException: Microsoft.Reporting.WebForms.ReportServerException: An error has occurred during report processing. (rsProcessingAborted) ---> Microsoft.Reporting.WebForms.ReportServerException:
Query execution failed for dataset 'DSMain'. (rsErrorExecutingCommand) ---> Microsoft.Reporting.WebForms.ReportServerException:
Microsoft.Crm.CrmException: An unexpected error occurred.
System.ServiceModel.Security.SecurityNegotiationException: A call to SSPI failed, see inner exception.
System.Security.Authentication.AuthenticationException: A call to SSPI failed, see inner exception.
System.ComponentModel.Win32Exception: The target principal name is incorrect ---> Microsoft.Reporting.WebForms.ReportServerException: An unexpected error occurred. ---> Microsoft.Reporting.WebForms.ReportServerException: A call to SSPI failed, see inner
exception. ---> Microsoft.Reporting.WebForms.ReportServerException: A call to SSPI failed, see inner exception. ---> Microsoft.Reporting.WebForms.ReportServerException: The target principal name is incorrect
