Cannot generate SSPI context

From: Mike Reed (mreed@visi.com)
Date: 10/31/02


From: "Mike Reed" <mreed@visi.com>
Date: Thu, 31 Oct 2002 10:43:32 -0600


The problem is after an undetermined time period of time the SSPI context.
The error message is "[Microsoft] [ODBC SQL Server Driver] Cannot generate
SSPI context." This happens on only two computers, one is a laptop
workstation, and the other is a desktop workstation both with Windows XP
Prof and Office XP Prof connected to a company wide domain of 30 or so and
one main server and a development server. When we first log onto domain,
all works ok. Then after an undetermined period of time the SSPI context is
lost to the SQL Server on both servers but not to the local SQL Server. We
essentially get the same error message weather we are connecting through an
in house developed application, the ODBC Manager, the SQL Enterprise
Manager, or the Quarry Analyzer. There seems to be no connections to the
programs running. The laptop is used by a Mechanical Engineer with his
associated programs and the desktop is a software development workstation.
We can print and read files from the servers.

I do not know if this is a Windows XP problem or an SQL problem. Any help
or suggestions would be appreciated.



Relevant Pages

  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • RE: migrating from wmsde to sql server
    ... Click Start, point to All Programs\Microsoft SQL Server, and then click ... then click New SQL Server Registration. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Best replication architecture?
    ... Looking for a SQL Server replication book? ... So if it is subscribing to Publisher 1, ...
    (microsoft.public.sqlserver.replication)
  • RE: Insufficient memory Available
    ... Insufficient memory available. ... within the scope of SQL Server. ... "MemToLeave" area. ...
    (microsoft.public.sqlserver.server)