Re: Cannot generate SSPI Context error

From: Uri Dimant (urid_at_iscar.co.il)
Date: 10/31/04 

Date: Sun, 31 Oct 2004 14:47:01 +0200

Peter
Perhaps it is because ADO.NET keeps pool connection by default. Have you ran
SQL Server Profiler?

"Peter B.L. Rasmussen" <PeterBLRasmussen@discussions.microsoft.com> wrote in
message news:422DFB2A-B95E-4309-B43A-5BD64EBDC093@microsoft.com...
> It happens Client-Side, in my application (VB.NET), when I am not working
in
> the application for some time. Then when the application (or the IDE)
tries
> to open a connection, it happens. If I keep the connection "alive" by
working
> in the application (or in the development IDE), it does not happen.
>
> Peter
>
> "Uri Dimant" wrote:
>
> > 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
> > >
> >
> >
> >

Relevant Pages

  • Re: Help -- SQLConnection Problem
    ... spend some time fiddling around with SQL Server Profiler. ... >> connection string will be used... ... >> Dim mySQLConnection As New System.Data.SqlClient.SqlConnection ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: [Microsoft][ ODBC SQL Server Drive ] Timeout expired
    ... I have been working on SQL server profiler ... > Have you considered taking ODBC or SQL Server Profiler traces? ... >> database using DSN connection using ODBC. ... Checked user permission set on the database. ...
    (microsoft.public.sqlserver.odbc)
  • RE: [ODBC SQL Server Driver][Shared Memory]ConnectionWrite (send()) er
    ... Thank you so much for your instruction. ... How can I check if the Connection pool was full or not. ... Does that mean we have database connection problem? ...
    (microsoft.public.sqlserver.connect)
  • Re: using(SqlConnection = ... ) ?
    ... It certainly doesn't log out the connection - or at least, ... looking at SQL Server Profiler. ... In fact, I've just tried executing sp_who2 myself with my test program, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Update cant work behind Linksys wireless router. Direct to AD
    ... Not sure what type of DSL connection your ISP offers but, see if this applies, Peter: ... Some 'thing' is blocking the connection to the update server. ... If the system can update successfully when connected directly to the modem than the Linksys router needs to have some settings adjusted. ...
    (microsoft.public.windowsupdate)