SQLServer-DBA.com Links

Subscribe to newsletter

Dba_db2_button

Powered by TypePad
SQL Server - SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed

18 January,2013 by Jack Vamvas

This error is reported on a server with SQL Server installed :

 

SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: xxxxxxxxxx]

 

Based on experience, this error occurs under different circumstances and can be tricky to diagnose. I’ve had to troubleshoot and issue various corrective mesaures:

1) If a Windows service account is used and the password changes. This is a common reason.

2) The SPNs are invalid. An SPN is the Server Principal Name utilized by Kerberos authentication.  In that case , delete the MSSQL SVC SPN and issue a SQL Server restart. This registers immediately.

3)Rights have been denied , analyse the local security policies.

Try running gpresult. Gpresult displays the Group Policy Settings and Resultant Set of Policy (RSOP) for the server. It should also tell you any problems/errors that it found when processing the GPOs.

 4)Check communications with AD .

 5) Is the server recognised?

Read More

Event ID 40960 Cannot generate SSPI context - SQL Server DBA

Database Connectivity test with Powershell - SQL Server DBA

SQL Server - SSPI handshake failed with error code 0x80090304 while establishing a connection with integrated security


Author: Jack Vamvas (http://www.sqlserver-dba.com)

******** *******

Subscribe to SQLServer-DBA.com

Latest posts delivered to you daily

Delivered by FeedBurner

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer