Export (0) Print
Expand All

Managing Logins and Passwords in Replication

Specify the logins and passwords for replication agents when you configure replication. For more information, see:

After configuring replication, change logins and passwords through the following methods:

If you change the password for an account used by a replication agent, execute sp_changereplicationserverpasswords (Transact-SQL). For more information, see How to: View and Modify Replication Security Settings (Replication Transact-SQL Programming).

ms151219.note(en-US,SQL.90).gifImportant:
The replication agent security model has changed significantly from SQL Server 2000. For detailed information about the security model, see Replication Agent Security Model. Replication scripts created from SQL Server 2000 or SQL Server 7.0 should be upgraded for SQL Server 2005 in order to take advantage of security enhancements. For more information, see How to: Upgrade Replication Scripts (Replication Transact-SQL Programming).

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft