Cannot generate SPPI context

[camaleonCHILE]

hi, i have a problem with my sql server connection.
we have some .net aplications running over SQL SERVER 2000
and Windows 2000. Sometimes, I get this error message: "Cannot generate SPPI context" when i wanna open the query analyzer. The same thing occurs with this aplications, the conection is broken.

thanks in advance

Regards

 

[philhege]

Grabbed these from a quick Google:

267588 "Cannot Generate SSPI Context" Error Message Is
Displayed When You Connect to SQL Server 2000

http://support.microsoft.com/?id=267588

811889 HOW TO: Troubleshoot the "Cannot Generate SSPI
Context" Error Message

http://support.microsoft.com/?id=811889

274438 Cannot Use Kerberos Trust Relationships Between
Two Forests in Windows 2000

http://support.microsoft.com/?id=274438

HTH,



Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
I'm not as think as you confused I am.
-----------
Flabbergasted (a.): Amazed at how much weight one has gained.
-----------
Oyster (n.): One who sprinkles their conversation with Yiddish expressions.

 

[mrdenny]

Typically when I've seen this one of these has happened:

1. The password for the account that the SQL Server is using has been changed and the SQL Server hasn't been restarted with the new password yet.

2. The account that the SQL Server is running under has been locked out / disabled.

3. There is a network problem preventing the SQL Server from talking to the domain controllers.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com