locked
The target principal name is incorrect - CRM 2015 - MSCRM_FetchDataSource RRS feed

  • Question

  • Hi all

    we have a problem with CRM & reporting services.

    We have three servers:
    1) CRM Application 2015 (with backend services)
    the user with which runs the CRM app pool has the SPN (http/serverName:7777 and http/serverName.domain:7777) and the user which run the Asynch and  Sandbox services have the spn.

    2) A server with SQL server 2014 on which the user that runs SQL has the spn (MSSQLSvc/SQLSERVERNAME and MSSQLSvc/SQLserverName.domain) 

    3) a dedicated server for reporting services.
    the user runs the reporting service has set the spn (http/SSRSServerName:80 and http/SSRSserverName.domain:80)
    CRM Reporting extensions is installed in this server.

    All reports generated by data source "MSCRM_FetchDataSource" fail with error "A call to SSPI failed, see inner exception. The target principal name is incorrect "

    SPNs are set and can not understand how it fails.
    in IIS "use appPoolCredential" it has been set to true.

    Can you help me understand what is the problem?

    Thank you,

    Alex


    • Edited by A_lex87 Tuesday, September 13, 2016 9:20 AM
    Tuesday, September 13, 2016 9:20 AM

All replies