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:
SQL Server Management Studio: How to: View and Modify Replication Security Settings (SQL Server Management Studio)
Replication Transact-SQL programming: How to: View and Modify Replication Security Settings (Replication Transact-SQL Programming)
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).
Important
The replication agent security model changed significantly in SQL Server 2005. For detailed information about the security model, see Replication Agent Security Model. Replication scripts created from SQL Server 2000 should be upgraded for SQL Server 2008 to take advantage of security enhancements. For more information, see How to: Upgrade Replication Scripts (Replication Transact-SQL Programming).
See Also