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


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

See Also


Replication Agent Security Model
Replication Security Best Practices

Other Resources

Security Considerations for Replication

Help and Information

Getting SQL Server 2005 Assistance