Re : Cannot generate SSPI context error

From: Vijay (vijay_at_atbay.com)
Date: 08/28/03 

Date: Thu, 28 Aug 2003 13:18:22 -0700

I am getting "Cannot generate SSPI context" error when I
am trying to connect using NT authentication from XP
Professional client to SQL server 2000. When I login I am
able to connect fine but after a while I begin to get this
error. If I log off and login I can once again connect and
work for a while but the problem reappears. However, I am
not facing the same problem with Win 2K professional
clients. I also got a call from a client and it seems to
be the similar kind of problem with NT workstations.

Any suggestions?

Relevant Pages

  • Re: Access link table security
    ... onerous chore of creating DSN's on each client. ... >and SQL Server is on the same machine. ... >How and where do I set at the Access frontend so that I can choose the login ... >change the login name for the Access frontend, do I need to play with ODBC ...
    (microsoft.public.sqlserver.security)
  • Re: SA Login
    ... Boris, ... Suppose that the client wants to apply the latest security patch to the ... SQL Server instance. ... Without any way to login as a member of the SysAdmin ...
    (microsoft.public.sqlserver.security)
  • no prompt on linked table
    ... I am hoping that someone might know a way to turn off the SQL Server Login ... request on how to first get the user id and password from the user. ... I can then pass the error information back to the client ...
    (microsoft.public.access.security)
  • no prompt on linked table
    ... am hoping that someone might know a way to turn off the SQL Server Login ... This will bring up a SQL Login dialog because dbo_JTEST is a linked table ... request on how to first get the user id and password from the user. ... I can then pass the error information back to the client ...
    (microsoft.public.access.security)
  • Re: Login failed for user ServernameGuest
    ... You cannot have SQL Server refer to an account on another machine, ... > On the Client computer I have a user CRAIS3. ... Computer Management) and looked at this login (Local ...
    (microsoft.public.sqlserver.server)