Microsoft ODBC sql driver cannot generate sspi context

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Justin - 19 Dec 2005 08:17 GMT

Hi,
I am facing a connection error occasionally. Im using MSDE2000a and
Dbamgr2k. The connection seems to have the following error
occasionally. Can anyone of u help me to troubleshoot this problem?
thank you.

Connection Failed
SQLState: 'HY000'
SQL Server Error: 1364
[Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context

Regards,
Justin

Reply to this Message

Ed Enstrom - 19 Dec 2005 23:04 GMT

> Hi,
> I am facing a connection error occasionally. Im using MSDE2000a and
[quoted text clipped - 9 lines]
> Regards,
> Justin

Are you connecting with a Windows account in a domain? If so, the machine running SQL Server may have lost connection
to the domain controller and can't authenticate your account credentials. Search MS support.

Reply to this Message

Justin - 22 Dec 2005 07:13 GMT

Thanx Ed Enstrom for your reply. I don't really get what you meant.
Maybe i should elaborate more on this. The pc is a standalone pc, OS is
xp pro, database using msde2000a. The error comes out from no where.
There are times which im able to connect to the sql server but
sometimes it shows the error of microsoft odbc sql server cannot
generate sspi context. Should i connect using the "sa" or by "trusted
NT connection" in dbamgr2k??

p/s: sorry, im a newbie here. thanx for your patience.

regards,
justin

Reply to this Message

Sam Hobbs - 24 Dec 2005 23:00 GMT

What Ed means by "Search MS support" is to search the MSDN and/or TechNet,
including the KB. I searched an old version of the MSDN for "Cannot generate
SSPI context" and got one result that says that the "native error will
contain the Win32 error code".

> Thanx Ed Enstrom for your reply. I don't really get what you meant.

Reply to this Message