737
Chapter 28: Replicating Data
28
Using the SQL Server Agent account is not considered to be a good security practice because buffer overfl ow, worm
attacks, or Trojan attacks might hijack the replication agent and run commands with the same security context as
the SQL Server Agent on the publisher, distributor, or subscriber. This dialog enables you to control which account the
replication agent is going to run under; ideally, this will be an account with as few rights as possible on the publisher,
distributor, or subscriber. Figure 28-1 illustrates this dialog.- Click the Security Settings button to display the Snapshot Agent Security dia-
log, as shown in Figure 28-2. From here, you can enter the Windows or SQL Server
Agent account under which you want the snapshot agent to run. If you choose a
Windows account, it needs to be added using the following syntax: DomainName/
AccountName. - After you select the agents you want to use, click OK, and then click Next to exit
the Agent Security dialog. - The Wizard Actions dialog displays. This enables you to create the publication
immediately, create a script to create the publication, or both. After you make your
selection, click Next. In the Complete the Wizard dialog that appears, you can name
your publication. - After you give your publication a name, click Finish to create it.
FIGURE 28-1
The Agent Security dialog.c28.indd 737c28.indd 737 7/31/2012 9:51:12 AM7/31/2012 9:51:12 AM
http://www.it-ebooks.info