Kerberos Authentication for SSAS named Instance: Error

  • Hi, I have configured Kerberos for SSAS named instance (Which is our APP server) and when I am trying to test if the connection is working I get the below error: (I am using Network Monitor to do the testing)

    KRB_ERROR - KDC_ERR_S_PRINCIPAL_UNKNOWN (7){TCP:88, IPv4:87}

    The service account has been trusted for delegation in AD and below are the SPN’s we set up:

    Named Instance: (SSAS01)

    Setspn –s msolapsvc.3/hostname:SSAS01 serviceaccount

    Setspn –s msolapsvc.3/FQDN:SSAS01 serviceaccount

    SQL Browser:

    Setspn -S MSOLAPDisco.3/Hostname:SSAS01

    Setspn -S MSOLAPDisco.3/FQDN:SSAS01

    Can you please let me know if there are pieces I am missing or if I have configured something wrong?

  • Servername: DBAS01.mydomain.local

    Named Instance: (SSAS01)

    Setspn –s msolapsvc.3/hostname:SSAS01 serviceaccount

    Setspn –s msolapsvc.3/DBAS01:SSAS01 mydomain\-svc-ssas01-account

    Setspn –s msolapsvc.3/DBAS01.MYDOMAIN.LOCAL:SSAS01 mydomain\-svc-ssas01-account

    Something like this?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply