Re: Cannot generate SSPI Context error
From: Uri Dimant (urid_at_iscar.co.il)
Date: 10/31/04
- Next message: Peter B.L. Rasmussen: "Re: Cannot generate SSPI Context error"
- Previous message: Peter B.L. Rasmussen: "Cannot generate SSPI Context error"
- In reply to: Peter B.L. Rasmussen: "Cannot generate SSPI Context error"
- Next in thread: Peter B.L. Rasmussen: "Re: Cannot generate SSPI Context error"
- Reply: Peter B.L. Rasmussen: "Re: Cannot generate SSPI Context error"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Sun, 31 Oct 2004 13:36:21 +0200
Peter
Where did it happen in an application or when you log in in EM/QA?
If it happend on ther client side , so perhaps some piece of code closes
connection. Can you run SQL Server Profiler to capture what is going on
during a half-two hours?
"Peter B.L. Rasmussen" <PeterBLRasmussen@discussions.microsoft.com> wrote in
message news:8C22E3CE-23E5-48AB-A30B-22A0506829E2@microsoft.com...
> I have a recurring problem with the "Cannot generate SSPI context" error.
It
> works fine for some time, but then it stops working. Generally after half
an
> hour - two hours time. A logoff/logon always fixes the problem.
> I have reviewed the 811889 article, but this doesn't help me. The
connection
> to the SQL server works fine, but at some time it is like the user looses
his
> credentials and then can't connect and SSPI won't reconnect him.
>
> Some basic info:
> Server is Windows 2000 server SP1 with AD. (was SP4 earlier, with the
same
> problem, so upgrading to SP4 will not solve the problem by itself. The
server
> has just been reinstalled from scratch, not finished SPs and updates yet)
> SQL Server is MSDE, client logging on with NT security, SQL Server is
> installed on the same physical server as the domain controller (only one
> domain controller exists)
> Client is XP PRO, same problem with SP2 or without SP2
> User on client is logged on to domain with Admin+Domain admin privileges
> Problem does not exist if client does not log on to domain
>
> Anybody got any ideas on how to solve this problem?
>
> Peter
>
- Next message: Peter B.L. Rasmussen: "Re: Cannot generate SSPI Context error"
- Previous message: Peter B.L. Rasmussen: "Cannot generate SSPI Context error"
- In reply to: Peter B.L. Rasmussen: "Cannot generate SSPI Context error"
- Next in thread: Peter B.L. Rasmussen: "Re: Cannot generate SSPI Context error"
- Reply: Peter B.L. Rasmussen: "Re: Cannot generate SSPI Context error"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
