ReplicationSecurity Object

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

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 object model that shows the current object

Properties

SecurityMode Property (ReplicationSecurity)

StandardPassword Property

StandardLogin Property

 

Remarks

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.