Re: SQL 2K SP3 Error: Could Not Generate SSPI Context

From: Steve Thompson (SteveThompson@nomail.please)
Date: 02/18/03


From: "Steve Thompson" <SteveThompson@nomail.please>
Date: Tue, 18 Feb 2003 12:16:36 -0500


"James Kita" <james.kita@peopleflow.com> wrote in message
news:O49X0211CHA.2076@TK2MSFTNGP10...
> I am running SQL 2000 with SP3, in mixed security mode, running on
WindowsXP
> Pro. When I try to connect with QA using Windows authentication, I
receive
> the error "Could Not Generate SSPI Context". As it happens, I am running
> remotely, away from the Domain Controller, but I had the same problem
while
> in the domain.
>
> Any possibilities?

Even though it's for SQL Server 7.0, see if this helps:
http://support.microsoft.com/default.aspx?scid=kb;en-us;269541

Steve



Relevant Pages

  • SQL 2K SP3 Error: Could Not Generate SSPI Context
    ... I am running SQL 2000 with SP3, in mixed security mode, running on WindowsXP ... Pro. ... When I try to connect with QA using Windows authentication, ... remotely, away from the Domain Controller, but I had the same problem while ...
    (microsoft.public.sqlserver.security)
  • Account Out of Sync I_NetLogonControl failed: ERROR_ACCESS_DENIED
    ... The member server has gone out of sync with the domain account: ... This computer was not able to set up a secure session with a domain ... If this computer is a domain controller for the specified domain, ... As we are running SQL is there any impact by doing any of the above? ...
    (microsoft.public.windows.server.sbs)
  • SQL 2000 Personal Edition sp3 and MS03-031
    ... I am running SQL 2000 Personal Edition sp3 and trying to install ... The problem is when it asks for credentials I select ... windows authentication and it returns "Invalid login information". ...
    (microsoft.public.sqlserver)
  • SQL 2000 Personal Edition sp3 and MS03-031
    ... I am running SQL 2000 Personal Edition sp3 and trying to install ... The problem is when it asks for credentials I select ... windows authentication and it returns "Invalid login information". ...
    (microsoft.public.sqlserver.msde)
  • Promoting to Domain Controller issues?
    ... We have a Win 2003 server currently running SQL 2000 as a standalone box. ... now would like to set the box as a domain controller as part of a our ...
    (microsoft.public.windows.server.general)