SSPI context -- sql server clients

Patricia Kline
7/31/2003 4:21:37 PM

we just re-did our server a few days ago, and ever since, i keep getting
this error:

Server: Msg11004, Level 16, State 1
[Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context.

To solve this problem, I have to re-boot my computer, however, I would a
better solution cause it happens several times a day.

Any suggestions.

Ray Higdon
7/31/2003 4:47:27 PM

Are you trying to connect via Windows authentication? I've
seen this error when first setting up an AD account on the
SQL Server, you might try dropping the login and re-adding
it.

HTH

Ray Higdon MCSE, MCDBA, CCNA

[quoted text, click to view]

Dinesh.T.K
8/1/2003 8:27:27 AM

Pat,

Try

HOW TO: Troubleshoot the "Cannot Generate SSPI Context" Error Message
http://support.microsoft.com/default.aspx?scid=kb;en-us;811889

--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server clients

sql server clients : SSPI context