通过

ReplicationSecurity Object

后续版本的 Microsoft SQL Server 将删除该功能。请避免在新的开发工作中使用该功能，并着手修改当前还在使用该功能的应用程序。

The ReplicationSecurity object represents authentication information used when connecting to a Distributor or Publisher. It is commonly used with pull and anonymous subscriptions.

显示当前对象的 SQL-DMO 对象模型

Properties

SecurityMode Property (ReplicationSecurity)

StandardPassword Property

StandardLogin Property

 

备注

With the ReplicationSecurity object, you can:

  • Enable Windows Authentication.
  • Enable SQL Server Authentication.

To enable Windows Authentication

  • Set the SecurityMode property to SQLDMOReplSecurity_Integrated.

To enable SQL Server Authentication

  1. Set the SecurityMode property to SQLDMOReplSecurity_Normal.

  2. Set the StandardLogin property to a Microsoft SQL Server login.

  3. Set the StandardPassword property to the password for the SQL Server login.