sql server replication: Dear All,

I can successfully create merge replication on the same
computer with two database instances. However, it didn't
success if I replicate over two computers.

I use push subscription and the subscriber seems
nothing to set (set the replication on the publisher).
Therefore, how can I control the access rights or else to
replicate to another computer?

Patrick,

the sql server agnt's login must be in the db_owner role on the subscriber
database, db_owner in the distribution database and db_owner of the
publishing database and have the correct rights to the snapshot share.

What is the error when you run the merge agent?

Regards,
Paul Ibison

Is there any step-by-step guide to setup replication over
different computers


[quoted text, click to view]