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

  • Question

  • hi,

    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 the spn setup (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


    Tuesday, September 13, 2016 7:46 AM

All replies

  • Check this reply from the previous thread

    https://social.microsoft.com/Forums/en-US/869a7cdf-a355-4c86-a1ce-368f118940a3/ms-dynamic-crm-2015-onpremises-unable-to-view-custom-report?forum=crmdevelopment#f5d094e9-4157-468d-8b4f-80946157d183


    If my response answered your question, please "mark the response as an answer" and also "vote as helpful". Regards, Hari. www.crm2011byhari.blogspot.com

    Tuesday, September 13, 2016 7:52 AM
  • Thank you for your support, but I have already set the SPN as described in your post, and still does not work.

    The error is the same "The target principal name is incorrect.

    Tuesday, September 13, 2016 9:15 AM
  • Hi,

    Check the error log on both Application and SQL machine from Event Viewer after replicating the issue. That may help you to narrow down the search for cause of issue.
     
    Thanks!
    Sam

    Inogic | Blog | news@inogic.com

    If this post answers your question, please click "Mark As Answer" on the post and "Mark as Helpful"

    Wednesday, September 14, 2016 1:01 PM