Microsoft OLE DB Provider for SQL Server"

I receive a "Cannot generate SSPI context" error message when you try to
connect to a SQL Server 2000 SP3 server computer.
According microsoft's article ID 843248 there is a hot fix. I do not want to
install SP2 just the hot fix.
Does anybody know the actual ID name of the hotfix. I am trying to connect
from XP SP1 Thank you
According to the article you referenced you could either download XP SP2 or
contact Product Support to get the fix.
In that article you can also find a workaround if you can not install either
SP2 or the fix.
I would recommend that you consider to install XP SP2 since it contains a
lot of security enhancements.
Simon
This posting is provided "as is" with no warranties and confers no rights.
"Yianni" <Yianni@.discussions.microsoft.com> wrote in message
news:B89BD7C7-E80B-48EE-943A-6832804665B5@.microsoft.com...
>I receive a "Cannot generate SSPI context" error message when you try to
> connect to a SQL Server 2000 SP3 server computer.
> According microsoft's article ID 843248 there is a hot fix. I do not want
> to
> install SP2 just the hot fix.
> Does anybody know the actual ID name of the hotfix. I am trying to connect
> from XP SP1 Thank you
>

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.