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
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.
