locked
Which SPN is being used? RRS feed

  • Question

  • Hi CRM friends,

    Setting SPN's has been something I've done a number of times in the past, but for one inparticular environment I'm at a list.  We've setup up the default SPN's, but I'm still running into issue with custom FetchXml reports not rendering.  The error we receive is

    "An error has occurred during report processing. (rsProcessingAborted)
    Query execution failed for dataset 'CMX'. (rsErrorExecutingCommand)
    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
    An unexpected error occurred.
    A call to SSPI failed, see inner exception.
    A call to SSPI failed, see inner exception.
    The target principal name is incorrect"

    So my question to everyone is, how can we determine which SPN's is the system looking for.  Is there some way to enable verbose logging in SSRS and see the SPN that is being looked for?  If not, is there another way to determine which SPN is missing or setup incorrectly?

    Wednesday, March 26, 2014 4:02 AM