Insights KERBEROS windows authentication error

When trying to install Insights 2021.10.x Insights using the Windows Authentification option for SQL, a Kerberos error appears

Issue Description:

  • When trying to install Insights 2021.10.x Insights using the Windows Authentification option for SQL, a Kerberos error appears
Checkpoints:
  • On the Insights SQL server please run the below command (with an admin user ):
    • SELECT auth_scheme FROM sys.dm_exec_connections WHERE session_id = @@spid ;
  • If the result is NTML this means that Kerberos is not enabled on SQL.
  • in this case, the customer IT/ AD Security team needs to check on the AD Domain side if Kerberos is enabled

Resolution:

  • the customer's IT/ AD Security team needs to check on the AD Domain side if Kerberos is enabled
  • also, the customer's DB Administrator has to enable Kerberos on SQL
    • afterward, have a refresh of the SQL and AD, then restart the installation of Insights 2021.10.x using Windows Authentification