Udostępnij za pośrednictwem


DistributorPassword Property (Replication ActiveX)

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

ms146949.security(en-US,SQL.90).gifSecurity Note:
When possible, prompt users to enter their credentials at run time. Avoid hard-coding or storing credentials in a file. If credentials must be persisted between runs, encrypt them using the Win32 CryptoAPI functions. For more information, see this Microsoft Web site.

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.

Applies To

SQLDistribution Object (Replication ActiveX)

SQLMerge Object (Replication ActiveX)

Remarks

This property is used only when DistributorSecurityMode Property (Replication ActiveX) is set to DB_AUTHENTICATION.

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.

Data Type

String

Modifiable

Read/write

Prototype C/C++

HRESULT get_DistributorPassword(BSTR *pVal);
HRESULT put_DistributorPassword(BSTR newVal);

See Also

Reference

DistributorLogin Property (Replication ActiveX)

Help and Information

Getting SQL Server 2005 Assistance