Databases Reference
In-Depth Information
8.5.3
Secure and monitor replication users
and connections
Because replication involves a complex architecture, many of the vendors
use multiple connections and multiple user accounts to manage and per-
form replication. As an example, when you configure SQL Server replica-
tion with a distributor that is separate from the publisher, you need to
configure a remoter distributor password. When you do this, a new SQL
Server user with System Administrator privileges is created with a password
that you assign within the publishing and distribution property editor, as
shown in Figure 8.12. The bottom line is that you now have a new user
with elevated privileges and additional servers connecting to your server
that you need to closely monitor and track.
Figure 8.12
Setting the
password for remote
connections to the
distributor.
Search WWH ::




Custom Search