Why SQL Server Kerberos authentication does not work?

0 votes

0 answers

1543 views

                          I am trying to find out why there is no Kerberos authentication on my SQL instance :

    SELECT COUNT (auth_scheme) as nb, auth_scheme --net_transport, client_net_address 
    FROM sys.dm_exec_connections
    GROUP BY auth_scheme

> nb	auth_scheme
> 
> 2	(Unknown)
> 
> 151	NTLM
> 
> 4	SQL

Using KerberosConfigurationManager, requiered SPNs seems to be correctly and automatically registered:

Here's the error log regarding the SPN for the instance :

Could you provide ideas to investigate why there is no Kerberos authentication?

All the conditions list at [this Microsoft Docs page](https://learn.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/cc280745(v=sql.105))  have been met.

EDIT :

Cannot add the output because this is confidential info, but the instance is correctly registered :

> MSSQLSvc/hostname.domainName.fr:instanceName

Asked by Mickael (325 rep)

May 3, 2018, 12:11 PM
Last activity: May 3, 2018, 03:11 PM

Why SQL Server Kerberos authentication does not work?

Related Questions