Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

TransSynchronizationAgent.DistributorPassword Property

 

Applies To: SQL Server 2016 Preview

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)

Public Overridable Property DistributorPassword As String

Property Value

Type: System.String

The password used.

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.

Return to top
Show:
© 2015 Microsoft