servers SQL2000 to SQL2005

Hi. I am struggling to link a SQL2005 box to a SQL2000 box via linked server.
I have done this before and am replicating what I did then but I can`t get it
to connect. However when I connect via query analyser using the same
credentials it connects with no issues. Has anyone seen this before ?
Si
Si,
Is there any difference in the Security tab of the linked server properties
from your model linked server?
Is Kerberos properly activated on both the SQL2005 and SQL200 boxes? (What
OS?)
Do you get any useful error messages when you try to use the linked server?
RLF
"Simon" <Simon@.discussions.microsoft.com> wrote in message
news:E71D6BEE-B7AC-4D6A-B48F-611AFAE89FE3@.microsoft.com...
> Hi. I am struggling to link a SQL2005 box to a SQL2000 box via linked
> server.
> I have done this before and am replicating what I did then but I can`t get
> it
> to connect. However when I connect via query analyser using the same
> credentials it connects with no issues. Has anyone seen this before ?
> Si