Fatal message: Error: 17806, Severity: 20

[Akash_pal]

We are receiving below error from many SQL servers. We don't know what the issue. Please let me know if someone know about this error.

Error Log - Fatal Current Process Error (severity level 20): SQL Server instance raised the following fatal message: Error: 17806, Severity: 20, State: 14. SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The Windows error code indicates the cause of failure. The logon attempt failed [CLIENT: xx.xx.xx.xxx]. The error message was raised by: Logon at: 13 February 2024 08:40:01.

[#2]

@Akash_pal 

There's a number of causes of this, however, the two I would focus on (based on you seeing this happens to many servers at once) from the Microsoft documentation below are:

1. Check the service account isn't being locked out by someone or something - even by the SQL database service itself;
2. If the account lives in a different forest to the SQL Servers themselves, check that cross-forest authentication is working.

• Cannot generate SSPI context when connecting to SQL Server - SQL Server | Microsoft Learn

Cheers,

Lain