Here’s a quickie; if you need to interoperate two SQL servers, one version 2000 and the other version 2005, then you must ensure that Service Pack 4 is installed on the 2000 version.
Otherwise it won’t be able to recognize the other SQL server.
Just thought I’d let you know.
Thanks!