Replication over different computers

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

>--Original Message--
>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
>
>.
>
|||Patrick,
BOL has all the details but not as a setup guide.
These links have step-by-step graphical setups:
http://www.mssqlcity.com/Articles/Re...MR/SetupMR.htm
http://www.sqlservercentral.com/arti...?categoryid=26
HTH,
Paul Ibison