March 11, 2016 at 1:56 pm
Hi All,
I need help to understand the issue more clearly
I am getting error every 15 min
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.
Login failed. The login is from an trusted domain and cannot be used with Windows authentication.
We are using Domain account as service account
when I run select auth_scheme from sys.dm_exec_connections where session_id=@@spid
it is giving NTLM not Kerbos
March 11, 2016 at 2:07 pm
Check this out: https://support.microsoft.com/en-us/kb/811889
March 22, 2016 at 3:25 pm
That is problem with the user. He changed his domain account password. After his computer restart, it is resolved again.
But now I am getting differently
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: <named pipe>]
There is no client IP address. It is showing named pipe
Named pipes is enabled in both client protocols & SQLL Server Protocols
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply