Managing Logins and Passwords in Replication
Specify the logins and passwords for replication agents when you configure replication. For more information, see:
- Setting Logins and Passwords When Configuring the Distributor
- Setting Logins and Passwords When Creating Publications
- Setting Logins and Passwords When Creating Subscriptions
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 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
Concepts
Replication Agent Security Model
Replication Security Best Practices
Other Resources
Security Considerations for Replication