• Article

MergePullSubscription.SecureInternetPassword Property

Sets the password (as a SecureString object) used when connecting to the Web server using HTTP Basic Authentication.

Namespace:  Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)

Syntax

'Declaration
Public Property SecureInternetPassword As SecureString
    Get
    Set
'Usage
Dim instance As MergePullSubscription
Dim value As SecureString

value = instance.SecureInternetPassword

instance.SecureInternetPassword = value

public SecureString SecureInternetPassword { get; set; }

public:
property SecureString^ SecureInternetPassword {
    SecureString^ get ();
    void set (SecureString^ value);
}

member SecureInternetPassword : SecureString with get, set

function get SecureInternetPassword () : SecureString
function set SecureInternetPassword (value : SecureString)

Property Value

Type: System.Security.SecureString
A SecureString value.

Remarks

The SecureInternetPassword property provides additional security for the password while it is stored in memory and should be used instead of InternetPassword.

When possible, prompt users to enter security credentials at runtime. If you must store credentials, use the cryptographic services provided by the Microsoft Windows .NET Framework.

The password is never returned by SecureInternetPassword.

You should use BasicAuthentication with Web synchronization. For more information, see Web Synchronization for Merge Replication.

The SecureInternetPassword property can only be set by members of the sysadmin fixed server role at the Subscriber or by members of the db_owner fixed database role on the subscription database.

Setting the SecureInternetPassword property is equivalent to executing sp_addmergepullsubscription_agent or sp_changemergepullsubscription.

The SecureInternetPassword property is availably only with instances of Microsoft SQL Server 2005.

This property is only used if the UseWebSynchronization property is true.