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:
- Set the Service Principal Names(SPN) value for the service account running the CRM Application Pool.
- 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