TransSynchronizationAgent.DistributorPassword Property

Gets or sets the password that is used when connecting to the Distributor by 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 
    Get 
    Set
'Usage
Dim instance As TransSynchronizationAgent 
Dim value As String 

value = instance.DistributorPassword

instance.DistributorPassword = value
public virtual string DistributorPassword { get; set; }
public:
virtual property String^ DistributorPassword {
    String^ get ();
    void set (String^ value);
}
abstract DistributorPassword : string with get, set 
override DistributorPassword : string with get, set
function get DistributorPassword () : String 
function set DistributorPassword (value : String)

Property Value

Type: System.String
The password used.

Implements

ITransSynchronizationAgent.DistributorPassword

Remarks

When possible, use Windows Authentication.

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 Distribution 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.

See Also

Reference

TransSynchronizationAgent Class

Microsoft.SqlServer.Replication Namespace