MS SQL Server Replication - Merge replication - 2 machines - same name

Author

Merge replication - 2 machines - same name - different domain

thedebacle@gmail.com

2006-01-26, 4:58 pm

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

Rafik Robeal

2006-01-26, 4:58 pm

It might be that MYSERVER is passed to the merge agent unqualified with the
domain name which could lead to this behavior. In order to confirm that you
can check the merge job command line parameters. You can even run the merge
agent manually on the command window and experiment with qualified server
name.

Let me know if this works

Thanks,

Rafik

--
This posting is provided "AS IS" with no warranties, and confers no rights.

<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
>

greggs@gmail.com

2006-02-17, 8:23 pm

I've tried several different things to follow your instructions. I
started out with editing just the merge agent's command arguments. I
have tried creating DOMAIN1\MYSERVER as a distributer and publisher and
have not had much success. I might be missing a few pieces. Could you
point me towards some specific SQL commands I could run to use the
qualified server name?

I have been able to set up a WINS entry to refer to DOMAIN1\MYSERVER as
MYSERVER-LOCATION1 and DOMAIN2\MYSERVER as MYSERVER-LOCATION2. This
has not helped my issue, I however have been able to set the snapshot
replication up properly with this.

Whenever I have tried to use the full qualified domain name
(Domain1\myserver) I have been unable to get any sort of replication
working. This leads me to believe I'm missing something in this
process. Any tips would be great.

Sponsored Links