SSPI handshake failed with error code 0x8009030c RRS feed

  • Question

  • Hi All,

    My client has told me that sometimes they face issues in accessing SQL and sometimes not.

    I checked all logs and other things...found nothing much....In Logs of SQL Server Agent I found one repeating error:

    Error: 17806, Severity: 20, State: 2.
     SSPI handshake failed with error code 0x80090311 while establishing a connection with integrated security; the connection has been closed. [CLIENT: ]

    I guess this is related to Protocols NTLM or Kerberoes......I am not famailiar in how to set SPN or something.....

    I m not sure is that the reason or not...but I assume this is coz i did not find anything else in the logs.

    Can somebody guide me how to proceed with this////
    Rahul Soni SQL DBA
    Saturday, January 30, 2010 7:55 AM


  • From this documentation


    0x80090311 error means

    No authenticating authority. Normally, this implies that the machine cannot contact a Domain Controller or from a Kerberos perspective (that is, a KDC). Troubleshoot this by turning on Kerberos Logging and getting a network monitor trace to determine where the computer is trying to contact for authentication. If you are traversing a trust then Netlogon log on Domain Controllers in both domains and if possible run a simultaneous trace to help pinpoint the failure.

    Saturday, January 30, 2010 12:45 PM