ReplicationServer.ChangeReplicationServerPasswords Method (ReplicationSecurityMode, String, SecureString)

Artikel
12/15/2008

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

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

Syntax

'Declaration
Public Sub ChangeReplicationServerPasswords ( _
    securityMode As ReplicationSecurityMode, _
    login As String, _
    password As SecureString _
)

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

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

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

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

Parameter

securityMode
Is the ReplicationSecurityMode value that specifies whether the login is used for Windows Authentication or SQL Server Authentication.

password
Is the password being changed, supplied as a SecureString value.

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

Hinweise

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(ReplicationSecurityMode,String,SecureString) method provides additional security for the password while it is stored in memory and should be used instead of ChangeReplicationServerPasswords(ReplicationSecurityMode,String,String).

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

Threadsicherheit

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.

Plattformen

Entwicklungsplattformen

Eine Liste der unterstützten Plattformen finden Sie unterHardware- und Softwareanforderungen für die Installation von SQL Server 2005.

Zielplattforme

Eine Liste der unterstützten Plattformen finden Sie unterHardware- und Softwareanforderungen für die Installation von SQL Server 2005.

Siehe auch

Verweis

ReplicationServer Class
ReplicationServer Members
Microsoft.SqlServer.Replication Namespace

Freigeben über