Solved

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

Posted on 2008-10-03
4
2,812 Views
Last Modified: 2012-05-05
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.
0
Comment
Question by:jriggin
4 Comments
 
LVL 32

Accepted Solution

by:
Daniel Wilson earned 250 total points
ID: 22635367
You're using Windows Authentication, right?

You're having intermittent problems with your domain controller.  Check its event log thoroughly.
0
 
LVL 32

Assisted Solution

by:bhess1
bhess1 earned 250 total points
ID: 22635395
This is not a simple issue, as there are multiple possible causes.  Please check:

http://support.microsoft.com/kb/811889

for the most common cases.  The blog posting at:

http://blogcastrepository.com/blogs/noel-davies_uk_ltd/pages/Howto-_2D00_-Troubleshoot-_1C20_Cannot-Generate-SSPI-Context_1D20_-Errors-.aspx

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.
0
 
LVL 1

Author Comment

by:jriggin
ID: 22949415
Sorry for abandoning this.  (It was actually asked by my daughter.)  Please split points as you proposed and close.

Thanks, all.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now