共用方式為

ReplicationServer.ChangeReplicationServerPasswords Method (ReplicationSecurityMode, String, String)

  • 發行項

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

命名空間: Microsoft.SqlServer.Replication
組件: Microsoft.SqlServer.Rmo (in microsoft.sqlserver.rmo.dll)

語法

'宣告
Public Sub ChangeReplicationServerPasswords ( _
    securityMode As ReplicationSecurityMode, _
    login As String, _
    password As String _
)

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

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

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

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

參數

  • securityMode
    Is the ReplicationSecurityMode value that specifies whether the login is used for Windows Authentication or SQL Server Authentication.
  • login
    Is the login for the stored password being changed.
  • password
    Is the password being changed.

例外

例外類型 狀況
ArgumentException

When the values of login or password are longer than 128 Unicode characters or contain null characters.

備註

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

執行緒安全性

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

平台

開發平台

如需受支援的平台清單，請參閱＜安裝 SQL Server 2005 的硬體和軟體需求＞。

目標平台

如需受支援的平台清單，請參閱＜安裝 SQL Server 2005 的硬體和軟體需求＞。

請參閱

參考

ReplicationServer Class
ReplicationServer Members
Microsoft.SqlServer.Replication Namespace