Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Cross Domain Server connections

Author  Topic 

Lisatech
Starting Member

1 Post

Posted - 2008-12-11 : 09:44:17
We are working with an application that has a summary database that is updated and replicated to outside companies. We are trying to determine how to connect the servers to setup replication without having a remote server connect with sa privileges. Can someone suggest what/how to configure the permissions for the initial connection from the remote server to the central server and suggest best practices for configuring the replication sessions.

All remote servers will be configured with a PULL subscription and be responsible for maintaining their own subscription.
   

- Advertisement -