MergeSynchronizationAgent.DistributorPassword Property

Article
12/03/2008

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)

Syntax

'Declaration
Public Overridable Property DistributorPassword As String

public virtual string DistributorPassword { get; set; }

public:
virtual property String^ DistributorPassword {
    String^ get ();
    void set (String^ newValue);
}

/** @property */
public String get_DistributorPassword ()

/** @property */
public void set_DistributorPassword (String newValue)

public function get DistributorPassword () : String

public function set DistributorPassword (newValue : String)

Remarks

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.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Share via