Export (0) Print
Expand All

MergeSynchronizationAgent.DistributorPassword Property

Topic Status: Some information in this topic is pre-release and subject to change in future releases. Pre-release information describes new features or changes to existing features in Microsoft SQL Server 2014.

Sets the password that is used when connecting to the Distributor using SQL Server Authentication.

Namespace:  Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Replication (in Microsoft.SqlServer.Replication.dll)

abstract DistributorPassword : string with get, set 
override DistributorPassword : string with get, set

Property Value

Type: String
The password.

Implements

IMergeSynchronizationAgent.DistributorPassword

When it is possible, we recommend that users enter security credentials at run time. If you must store credentials, use the cryptographic services provided by the Microsoft .NET Framework.

For a push subscription, the Merge Agent always connects to the Distributor locally by using Windows Integrated Authentication, and this property is ignored.

Stored passwords that are used to connect to the Distributor are never returned. Accessing this property will generate a PasswordWriteOnlyException exception.

This property is used only when DistributorSecurityMode is set to Standard.

If the Distributor connection properties are not specified, it is assumed that the Publisher and Distributor are the same instance of SQL Server, and that Publisher connection properties will be used when connecting to the Distributor.

Community Additions

Show:
© 2014 Microsoft