connection failed from client application

Hi ,
the client application used is ms access via odbc to sql server 2000 std
edition sp3a
sometimes the user just get the following error :
1 - Connection failed , SQL state : S1000 , SQL Server Error : 0 Cannot
generate SSPI context
2 - Connection failed , SQL state : HY000 , SQL Server Error : 0 Cannot
generate SSPI context
does anyone knows wat's the cause and how to resolve
if need to reinstall the odbc , how can i do that ?
tks & rdgsHi
You may want to check out
http://support.microsoft.com/kb/811889/
http://support.microsoft.com/defaul...kb;en-us;267588
http://support.microsoft.com/defaul...kb;en-us;814401
John
"maxzsim" wrote:

> Hi ,
> the client application used is ms access via odbc to sql server 2000 std
> edition sp3a
> sometimes the user just get the following error :
> 1 - Connection failed , SQL state : S1000 , SQL Server Error : 0 Cannot
> generate SSPI context
> 2 - Connection failed , SQL state : HY000 , SQL Server Error : 0 Cannot
> generate SSPI context
> does anyone knows wat's the cause and how to resolve
> if need to reinstall the odbc , how can i do that ?
> tks & rdgs
>