Microsoft ODBC sql driver cannot generate sspi context

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,
JustinJustin wrote:
> 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
>
Are you connecting with a Windows account in a domain? If so, the machine r
unning SQL Server may have lost connection
to the domain controller and can't authenticate your account credentials. S
earch MS support.|||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|||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".
"Justin" <justin@.smsit.com.my> wrote in message
news:1135235596.227999.154030@.z14g2000cwz.googlegroups.com...
> Thanx Ed Enstrom for your reply. I don't really get what you meant.