Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Kerberos Authentication for SSAS Error

Author  Topic 

sqlserver_22005367
Starting Member

1 Post

Posted - 2014-02-19 : 14:08:23
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?
   

- Advertisement -