• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3385
  • Last Modified:

Microsoft SQL Server Login- Connedction failed- SQL State: "s1000"- [Microsoft][ODBC SQL Server Driver] Cannot generate SSPI context

I've checked all the ODBC connections to this server and they all tested fine.. and this error only happens randomly.. and its really aggravating.
2 Solutions
Daniel WilsonCommented:
You're using Windows Authentication, right?

You're having intermittent problems with your domain controller.  Check its event log thoroughly.
Brendt HessSenior DBACommented:
This is not a simple issue, as there are multiple possible causes.  Please check:


for the most common cases.  The blog posting at:


is also a good discussion on this subject, and may be very helpful to you.  I would start with the blog posting, as it is generally more readable.
jrigginAuthor Commented:
Sorry for abandoning this.  (It was actually asked by my daughter.)  Please split points as you proposed and close.

Thanks, all.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now