linkedServer fails from client when logged-in with NT-auth sql2k c

delegation on linked server fails in our network when we use nt-authenticate
d
logins. we have sql server 2000 nodes n1,n2 on win 2003 cluster. linked
server from n1 to n2 and n2 to n1 stop working when used in a query from
clinet xp pc.
we can query individually the servers(nodes/instances) from client and from
server nodes to server instances without any error.
the error we get is " msg xxx err xx Reason: login failed for user (NULL)
....."
Any thots,hints,links,pointers appreciated
Thanks,
GAGA,
If you are using the setting where the current login on server A is supposed
to pass through to server B and if one of the servers is not properly set up
for Kerberos delegation, you will have a problem.
RLF
"DallasBlue" <DallasBlue@.discussions.microsoft.com> wrote in message
news:7405A4DD-F0A5-478F-8569-6CC3F9BE120B@.microsoft.com...
> delegation on linked server fails in our network when we use
> nt-authenticated
> logins. we have sql server 2000 nodes n1,n2 on win 2003 cluster. linked
> server from n1 to n2 and n2 to n1 stop working when used in a query from
> clinet xp pc.
> we can query individually the servers(nodes/instances) from client and
> from
> server nodes to server instances without any error.
> the error we get is " msg xxx err xx Reason: login failed for user (NULL)
> ....."
> Any thots,hints,links,pointers appreciated
> Thanks,
> GA
>