SQL – SSPI handshake failed with error code 0x8009030c (eventid 17806)

Problem

Repeated errors in EventLog, eventid 17806

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. [CLIENT: 192.168.X.Y].

events-sql-17806

 

Solution

1. Go to register start > run
2. Type Regedit
3. Go to: HKLM\System\CurrentControlSet\Control\LSA
4. Add a DWORD value called “DisableLoopbackCheck”
5. Set this value to 1
6. Reboot after making this change.

Platform

Windows 2008 R2
MS SQL 2008

Hits: 947

Leave a Reply