809
This blog post provides a simple SQL script that you can use to check if Kerberos authentication is enabled for your SQL Server instance. By using this script, you can quickly and easily ensure that Kerberos authentication is enabled for your SQL Server instance, and take the necessary steps to secure your environment.
T-Sql
/*
This script checks if Kerberos authentication is enabled for the current session in SQL Server.
If the result of the query is "KERBEROS" then Kerberos authentication is enabled.
Make sure you are connected to the correct instance of SQL Server before running this script.
*/
SELECT
CASE
WHEN auth_scheme = 'KERBEROS' THEN 'Kerberos authentication is enabled'
ELSE 'Kerberos authentication is not enabled'
END AS [Status]
FROM sys.dm_exec_connections
WHERE session_id = @@SPID
