<thedebacle@gmail.com> wrote in message
news:1138307691.765494.21580@z14g2000cwz.googlegroups.com...
> Here I my setup:
>
> I have MS SQL Server 2000 running on two servers both named MYSERVER.
> These servers are both on different domains, DOMAIN1 and DOMAIN2.
>
> I set up Merge replication for TESTDB on DOMAIN1\MYSERVER
>
> I created TESTDB on DOMAIN2\MYSERVER
>
> After I set up the push subscription from DOMAIN1\MYSERVER to
> DOMAIN2\MYSERVER the bulk copy process seems to work correctly. If I
> view the tables in TESTDB on DOMAIN2\MYSERVER the data appears in
> there.
>
> I view the merge agent and it always fails. Here are the error
> messages:
> The subscription to publication 'TESTDB' is invalid.
> Last Command: {call sp_MSgetreplicainfo(?,?,?,?,?,?,?)}
>
> The remote server is not defined as a subscription server.*
>
> *I think what this is communicating is that DOMAIN2\MYSERVER sees that
> it is looking for a "MYSERVER," however; it finds itself instead of
> DOMAIN1\MYSERVER and doesn't know what to do.
>
> I have successfully set up merge replication between DOMAIN1\MYSERVER
> and DOMAIN1\SECONDSERVER. Everything works fine with that.
>
> I have also successfully set up Snaphot replication to push data from
> DOMAIN1\MYSERVER to DOMAIN2\MYSERVER.
>
> I have also tried pulling the data from DOMAIN1 to DOMAIN2 with no
> success.
>
> Any help would be great. Thanks!!
>
> Adam
>