SQL Server Login failed

SQL Server Error: 17806, Severity: 20, State: 14. SSPI handshake failed with error code 0x8009030c, state 14

Vamshi B
March 31, 2017
1 Comment
SQL Server, SQL Server Admin, SQL Server Administration, SQL Server Errors

SQL Server Error: 17806, Severity: 20, State: 14.
SSPI handshake failed with error code 0x8009030c, state 14

Details of Error:

Error: 17806, Severity: 20, State: 14. 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.

These errors appear in SQL Error logs.

Cause of Error:

Can be due to multiple causes like

1. This issue can be related to Kerberos and most of the SSPI handshake error messages due to Kerberos failure. Kerberos failure can be most likely be related to non-existent SPN (Service Principal Name) or bad SPN for SQL … Read the rest

Login failed for [SQLSTATE 28000] (Error 18456) the step failed SQL Server

Vamshi B
February 20, 2017
SQL Server Admin, SQL Server Administration, SQL Server Errors, SQL Server Security

Login failed for [SQLSTATE 28000] (Error 18456) the step failed SQL Server

Details of Error:

Executed as user: Domain\LoginName. Login failed for user 'Domain\LoginName'. [SQLSTATE 28000] (Error 18456). The step failed.

or below ODBC Data Source SQL Server Connection – Login Failed For User

Connection failed: SQLState: '28000' SQL Server Error: 18456 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'UserName'.

Cause of Error:

This error is encountered when SQL Agent Service does not have permissions required to run the job. Or When we try ODBC Data Source SQL Server Connection Login Failed message when Login used for connection does not have permission needed.

Resolution:

First if this message is caused by SQL Agent Job … Read the rest

Cookie	Duration	Description
cookielawinfo-checkbox-analytics	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional	11 months	The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy	11 months	The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.