February 2, 2011 at 12:22 am
I got the below error in the Application eventviewer of the SQL Server:
SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: 12.05.127.8].
Many errors are actually logged in the SQL Server Error Log.
Message
[298] SQLServer Error: 848, Cannot generate SSPI context [SQLSTATE HY000]
Message
[298] SQLServer Error: 848, SQL Network Interfaces: The system detected a possible attempt to compromise security. Please ensure that you can contact the server that authenticated you. [SQLSTATE HY000]
Can anybody please suggest what is going wrong and how to prevent it?
I'd an idea might be due to this for the cause of the domain password change issue and it took little longer time to replicate through the network and SSPI content error arised.
select auth_scheme,net_transport from sys.dm_exec_connections
Output:
---------
auth_scheme net_transport
------------------- ------------------------
NTLM TCP
The Authentication Scheme is NTLM, not 'Kerberos'. is this an issue? I checked with team mate and came to know since beginning this was the NTLM.
Please suggest how to get rid of the issue/trouble.
Thanks.
February 2, 2011 at 1:05 am
It's an Active Directory issue IMHO.
I have been experiencing something similar and found out that the AD server had to be patched. Is it w2k3?
-- Gianluca Sartori
February 2, 2011 at 1:30 am
Yes, it is Wondows Server 2003, Service Pack 2
Thanks.
February 2, 2011 at 2:05 am
It could definiely be a different case, but this is the issue we were experiencing:
http://support.microsoft.com/kb/973667/en-us
I hope this helps in your scenario as well.
Gianluca
-- Gianluca Sartori
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply