none
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