pds_integrated_security

(Microsoft SQL Server only) Determines if Replication Agent should use Windows authentication when connecting to the primary SQL Server.

Note: This parameter is available only for Microsoft SQL Server.

Default

false

Value

true – Specifies that Replication Agent should connect to the primary SQL Server using Windows authentication.

false – Specifies that Replication Agent should connect to the primary SQL Server using SQL Server authentication (default).

Comments

  • The default value for pds_integrated_security is set to false when a Replication Agent instance is created. In this default setting, you must configure the pds_password parameter, and the primary SQL Server must be configured to allow SQL Server authentication.

  • Set this value to true to have Replication Agent connect to the primary SQL Server using Windows authentication. The Windows environment and the primary SQL Server must be configured to use Windows authentication. For more information, see the Microsoft SQL Server section in the Replication Agent Primary Database Guide.