日志读取器代理的安全性(对等复制)Log Reader Agent Security (Peer-to-Peer Replication)

适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) 适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions)

可以使用 “日志读取器代理安全性” 页,指定日志读取器代理在各对等方运行和建立连接时使用的帐户。The Log Reader Agent Security page allows you to specify the accounts under which the Log Reader Agent at each peer runs and makes connections. 有关代理要求的权限及复制安全的最佳做法的信息,请参阅复制代理安全模型复制安全最佳做法For information on permissions required by agents and best practices for replication security, see Replication Agent Security Model and Replication Security Best Practices.

备注

对于使用事务复制发布的每个数据库,都有一个日志读取器代理。There is one Log Reader Agent for each database that is published using transactional replication. 如果已经配置数据库的日志读取器代理(不管是在上一次运行此向导时针对发布配置的,还是针对同一数据库中另一个事务发布配置的),则不能在此向导中更改该代理使用的凭据。If the Log Reader Agent for a database has already been configured (either for a publication in a previous run of this wizard or for another transactional publication in the same database), you cannot change the credentials it uses in this wizard. 如果指定新凭据,它们将被忽略。If you specify new credentials, they are ignored. 若要更改凭据,请使用 “发布属性” 对话框。To change credentials, use the Publication Properties dialog box. 有关详细信息,请参阅 View and Modify Replication Security SettingsFor more information, see View and Modify Replication Security Settings.

选项Options

在各对等方的行中单击属性按钮 ( ... ),可以访问 “日志读取器代理安全性” 对话框。Click the properties button (...) in the row for each peer to access the Log Reader Agent Security dialog box. 若要了解有关代理所使用帐户需要的权限的详细信息,请在 “日志读取器代理安全性” 对话框启动后单击其中的 “帮助”Click Help on the Log Reader Agent Security dialog box that is launched for more information on the permissions required for accounts used by the agents.

在对话框中输入设置之后,网格中将显示订阅服务器的连接信息。After settings have been entered in the dialog box, connection information for the Subscriber is displayed in the grid.

发布服务器的代理Agents for Publisher
每个对等服务器实例的名称。The name of each peer server instance.

对等数据库Peer Database
各对等方上用作发布数据库和订阅数据库的数据库。The database that serves as the publication database and subscription database at each peer.

与分发服务器的连接Connection to Distributor
连接到分发服务器时所处的上下文。The context under which the connection to the Distributor is made. 与分发服务器的本地连接始终是使用运行代理的 MicrosoftMicrosoft Windows 帐户的上下文建立的,因此,此字段将始终显示“模拟‘<Domain>\<登录名>’”或“模拟‘<Computer>\<登录名>’”。The local connection to the Distributor is always made using the context of the MicrosoftMicrosoft Windows account under which the agent runs, so this field will always display Impersonate '<Domain>\<Login>' or Impersonate '<Computer>\<Login>'.

与发布服务器的连接Connection to Publisher
与发布服务器建立连接时所处的上下文。The context under which the connection to the Publisher is made. 通过使用 MicrosoftMicrosoft SQL ServerSQL Server 登录名,或使用运行代理的 Windows 帐户的上下文,可以与发布服务器建立连接。The connection to the Publisher can be made using a MicrosoftMicrosoft SQL ServerSQL Server login or using the context of the Windows account under which the agent runs. 该字段显示下列选项之一:使用登录名“<Login>”、模拟“<Domain><登录名>”或模拟“<Computer>\<登录名>” \The field displays one of the following: Use login '<Login>', Impersonate '<Domain>\<Login>' or Impersonate '<Computer>\<Login>'. MicrosoftMicrosoft 建议使用 Windows 帐户的上下文建立所有连接。recommends that all connections be made using the context of the Windows account.

另请参阅See Also

管理对等拓扑(复制 Transact-SQL 编程) Administer a Peer-to-Peer Topology (Replication Transact-SQL Programming)
@loopback_detectionPeer-to-Peer Transactional Replication