Microsoft Dynamics CRM 2011 Report Displayed Error

By - July 5, 2012

Recently, I have ran into a Reporting issue in Microsoft Dynamics CRM for one of my client. He was not able to run the out-of-the box CRM reports that were customized. The Reported Error gives you an error “The report cannot be displayed. (rsProcessingAborted).” 

So I checked his SQL Report Service Log and found a call to SSPI failed. The exact error from the log

 “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”

After doing a bit of research, I found a KB article by Microsoft with a solution to the same error.

The cause:

The FetchXML query needs to be able to resolve to a HTTP SPN in order to fully communicate between the server. In a scenario where the Microsoft Dynamics CRM application pool is being run by a domain account the query will be looking for a HTTP SPN that does not exist by default.

The solution involves two steps:

  1. Set the Service Principal Names(SPN) value for the service account running the CRM Application Pool.
  2. Set the IIS useAppPoolCredentials value to True for the CRM website.

More detailed steps in this Microsoft KB solution article: http://support.microsoft.com/kb/2590774

After applying those steps, my client was able to run out-of-the box CRM reports that were customized again.

If you are looking for support services for your Microsoft Dynamics CRM system, RSM offers a full range of services from implementation and optimization to development and support.  Contact our professionals for more information on our services at 855.437.7202 or crm@mcgladrey.com.

By:  Hien Tieu – New Jersey Microsoft Dynamics CRM Specialist

Receive Posts by Email

Subscribe and receive notifications of new posts by email.