locked
Authentication failed. (Microsoft.AnalysisServices.AdomdClient). The target principal name is incorrect (Microsoft.AnalysisServices.AdomdClient) RRS feed

  • Question

  • Hi Experts,

    We had a task to  migrate SQL Server all the components to another server, the migration went well and had no issues at all. but We can login to SSAS service locally wihtout any issues. when we are connecting the analysis services from the other machines(servers) it is givng the below error.

    Authentication failed. (Microsoft.AnalysisServices.AdomdClient)
    The target principal name is incorrect (Microsoft.AnalysisServices.AdomdClient)


    1) it is a stand alone server

    2) it is connecting to default instance but not to a named instance

    3) SPN's were set correctly. Double checked with the tool(MS Kerberos configuration Tool).

    4) The SQL server analysis start account has domain admin privileges.

    5) we can connect to Database services from the other machine remotely.

    6) none of the analysis services are  connecting.

    Thank you in advance.



    • Edited by Ramu thoutu Friday, October 31, 2014 7:54 AM
    Friday, October 31, 2014 7:48 AM

Answers

  • Hi Ramu,

    According to your description, you migrated SQL Server to another server, everything works fine except that cannot connect to SSAS remotely with the error, right?
    Authentication failed. (Microsoft.AnalysisServices.AdomdClient)
    The target principal name is incorrect (Microsoft.AnalysisServices.AdomdClient)

    Based on my research, this issue is caused by that the SPN for account that run the Analysis Services is corrupt. You said that the SPN were set correctly, however the error message indicate that the problem is related to SPN. So in your scenario, you can delete the SPN under the service account, and register SPN for Analysis Services instance. Please refer to the link below to see the details.
    http://msdn.microsoft.com/en-IN/library/dn194200.aspx

    Besides, here is a blog which describe the similar issue.
    http://www.wolfsoftwaresystems.com/code/sql/the-target-principal-name-is-incorrect-microsoft-analysisservices-adomdclient/

    Regards,


    Charlie Liao
    TechNet Community Support

    • Proposed as answer by Charlie Liao Friday, November 7, 2014 8:30 AM
    • Marked as answer by Charlie Liao Sunday, November 9, 2014 12:15 PM
    Tuesday, November 4, 2014 7:34 AM