Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Troubleshooting Cannot Generate SSPI Context Errors Expand / Collapse
Author
Message
Posted Monday, August 21, 2006 12:47 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 10, 2007 7:57 AM
Points: 7, Visits: 1

Hi,

I've been experiencing this problem for a long time and this is the first article or reference I have found that addresses it. We have SQL Server 2000 sp3 running on Windows Server 2003 at a client's site, and a client/server application written in VB6 that accesses it, and we get this error intermittently. We've just been telling them to log off and log on again! I'll try the suggestion in this article.

Daniel

Post #302999
Posted Monday, August 21, 2006 5:03 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, July 12, 2014 5:11 PM
Points: 126, Visits: 499

Chad,

   thanks for the article, I as well have seen this error and everytime I try to research it all I find are documents from the perspective of Kerbos in general, or from the point of view of a Network administrator (which I am not).  You elluded to part of the answer in your article and I have re-printed the quote below

"(see KLIST and KERBTRAY.EXE Windows 2000 Resource Kit utilities to view current tickets). "

My question is how do I know if a connection is comming in as kerbos or is demoting to NTLM.  What was your perspective on using Klist or the KerbTray.exe applications to view Kerbos connections.  How did you view NTLM conections? From this where there any tricks learned?  Ofcourse I'm off to try myself, but I thought I would bring it up as a possible add in to the next revision of this Doc (if any).  Ideally I would like to know how to check each of the three types of connections so that I might know definitely how my connection are occuring to the database.

The 3 types

1. NTLM over Named Pipes (not using SSPI)

2. NTLM over TCP-IP sockets via SSPI

3. Kerberos over TCP-IP sockets via SSPI

 

Thanks,

Mudluck

 




Post #303079
Posted Tuesday, August 22, 2006 11:13 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 23, 2006 5:46 AM
Points: 3, Visits: 1
I'm also getting the SSPI Context error due to changing the system time on the server for test purposes.  Is there really no way of doing this without getting an error?  How do you simulate the passing of time when testing?
Post #303272
Posted Monday, January 22, 2007 7:19 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Today @ 8:56 AM
Points: 58, Visits: 139
I was able to get around this issue by setting up an alias for the server giving me trouble in the Client Network Utility.
Post #338649
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse