ReplicationServer.ChangeReplicationServerPasswords 메서드 (ReplicationSecurityMode, String, String)

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

네임스페이스:  Microsoft.SqlServer.Replication
어셈블리:  Microsoft.SqlServer.Rmo(Microsoft.SqlServer.Rmo.dll)

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

매개 변수

securityMode
유형: Microsoft.SqlServer.Replication.ReplicationSecurityMode
Is the ReplicationSecurityMode value that specifies whether the login is used for Windows Authentication or SQL Server Authentication. 가능하면 Windows 인증을 사용하십시오.
login
유형: System.String
Is the login for the stored password being changed.
password
유형: System.String
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).

커뮤니티 추가 항목

추가
표시: