ReplicationSecurity Object

SQL-DMO

SQL-DMO

ReplicationSecurity Object

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

Properties
SecurityMode Property (ReplicationSecurity) StandardPassword Property
StandardLogin Property  
Remarks

With the ReplicationSecurity object, you can:

  • Enable Windows NT Authentication.

  • Enable SQL Server Authentication.

To enable Windows NT Authentication

  • Set the SecurityMode property to SQLDMOReplSecurity_Integrated.

To enable SQL Server NT 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.