differences in the authentication scheme - could it be because of Kerberos?

by marcello miorelli   Last Updated July 11, 2019 17:06 PM

I am using this script to check the connections to my sql server:

select
C.client_net_address,
S.host_name,
 c.session_id,
 c.net_transport,
 c.protocol_type,
 c.auth_scheme,
 s.program_name
from sys.dm_exec_connections c
inner join sys.dm_exec_sessions s
on c.session_id = s.session_id;

I have noticed that our servers in the UK are generally different to the servers in the US.

US:

enter image description here

UK:

enter image description here

I have found a very interesting link:

Kerberos Authentication requires that you have Service Principal Names registered

and I was wondering if that could be the case for the differences in the authentication scheme on the pictures above.



Related Questions



NTLM vs Kerberos authentication - questions

Updated February 04, 2019 22:06 PM

Locked my sa user out

Updated May 08, 2019 12:06 PM