Insights KERBEROS windows authentication error

[system]

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