Artigo
09/28/2010

Método ChangeReplicationServerPasswords (ReplicationSecurityMode, String, String)

Changes all stored instances of the password for a login maintained on the replication server.

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

Sintaxe

'Declaração
Public Sub ChangeReplicationServerPasswords ( _
    securityMode As ReplicationSecurityMode, _
    login As String, _
    password As String _
)
'Uso
Dim instance As ReplicationServer
Dim securityMode As ReplicationSecurityMode
Dim login As String
Dim password As String

instance.ChangeReplicationServerPasswords(securityMode, _
    login, password)

public void ChangeReplicationServerPasswords(
    ReplicationSecurityMode securityMode,
    string login,
    string password
)

public:
void ChangeReplicationServerPasswords(
    ReplicationSecurityMode securityMode, 
    String^ login, 
    String^ password
)

member ChangeReplicationServerPasswords : 
        securityMode:ReplicationSecurityMode * 
        login:string * 
        password:string -> unit

public function ChangeReplicationServerPasswords(
    securityMode : ReplicationSecurityMode, 
    login : String, 
    password : String
)

Parâmetros

securityMode
Tipo: Microsoft.SqlServer.Replication. . :: . .ReplicationSecurityMode
Is the ReplicationSecurityMode value that specifies whether the login is used for Windows Authentication or SQL Server Authentication. Quando possível, use a Autenticação do Windows.

password
Tipo: System. . :: . .String
Is the password being changed.

Exceções

Exceção	Condição
ArgumentException	When the values of login or password are longer than 128 Unicode characters or contain null characters.

Comentários

The ChangeReplicationServerPasswords method is used to update the password for a login used by replication agents to connect to other servers in the replication topology after the password for this login has been changed. This method is used instead of individually changing the password for each stored instance of the login used for each agent connection.

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

Calling ChangeReplicationServerPasswords is equivalent to executing sp_changereplicationserverpasswords (Transact-SQL).