DistributorPassword Property

Replication Programming

Replication Programming

DistributorPassword Property

The DistributorPassword property sets or returns the login password used when connecting to the Distributor.

Applies To

SQLDistribution Object

SQLMerge Object

SQLSnapshot Object

Syntax

object.DistributorPassword [= string]

Part Description
object Expression that evaluates to an object in the Applies To list.
string Password string used when connecting to the Distributor.
Remarks

This property is used only when DistributorSecurityMode is set to DB_AUTHENTICATION. Specify a NULL password as follows:

   objMerge.DistributorPassword = ""

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

The default is no password.

Data Type

String

Modifiable

Read/write

Prototype C/C++

HRESULT get_DistributorPassword(BSTR *pVal);

HRESULT put_DistributorPassword(BSTR newVal);

See Also

DistributorLogin Property

DistributorSecurityMode Property