Setting Logins and Passwords When Configuring the Distributor
This topic covers the following areas related to configuring a Distributor:
- Snapshot folder security
- Remote distributor
Snapshot Folder Security
Ensure that the snapshot share has read access granted to the account under which the Merge Agent (for merge replication) or Distribution Agent (for snapshot or transactional replication) runs and write access granted to the account under which the Snapshot Agent runs. For more information about the snapshot folder, see Securing the Snapshot Folder.
Remote Distributor
If you use a remote Distributor, you must specify a password, which the distributor_admin account uses for administrative replication stored procedures that execute at the Publisher and connect to the Distributor. For more information, see Securing the Distributor. For more information about specifying the password, see:
- SQL Server Management Studio: How to: Configure Distribution (SQL Server Management Studio)
- Replication Transact-SQL programming: How to: Configure Publishing and Distribution (Replication Transact-SQL Programming)
For more information about changing the password, see:
- 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)
See Also
Tasks
How to: View and Modify Replication Security Settings (SQL Server Management Studio)
Concepts
Replication Security Best Practices
Securing the Distributor
Other Resources
Managing Logins and Passwords in Replication
How to: View and Modify Replication Security Settings (Replication Transact-SQL Programming)