• Article

ReplicationServer.InstallDistributor Method (String, SecureString)

Registers a remote Distributor, where the password is specified using a SecureString object.

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

Syntax

'Declaration
Public Sub InstallDistributor ( _
    distributionServerName As String, _
    password As SecureString _
)
'Usage
Dim instance As ReplicationServer
Dim distributionServerName As String
Dim password As SecureString

instance.InstallDistributor(distributionServerName, _
    password)

public void InstallDistributor(
    string distributionServerName,
    SecureString password
)

public:
void InstallDistributor(
    String^ distributionServerName, 
    SecureString^ password
)

member InstallDistributor : 
        distributionServerName:string * 
        password:SecureString -> unit 

public function InstallDistributor(
    distributionServerName : String, 
    password : SecureString
)

Parameters

  • distributionServerName
    Type: System.String
    A String value that specifies the name of the remote server to be used as the Distributor for the current Publisher server. The distribution server name cannot be the same as the current server.

Remarks

This method must be called from a Publisher to register the remote Distributor. If the Publisher and Distributor are on the same server, you should not call this method.

Before calling InstallDistributor(String, SecureString), you must have called InstallDistributor(SecureString, DistributionDatabase) at the Distributor.

The InstallDistributor(String, SecureString) method provides additional security for the password while it is stored in memory and should be used instead of InstallDistributor(String, String).

The InstallDistributor method can only be called by a member of the sysadmin fixed server role.

The InstallDistributor method is equivalent to executing the sp_adddistributor (Transact-SQL) stored procedure at the Publisher to register a remote Distributor.

This namespace, class, or member is supported only in version 2.0 of the .NET Framework.