Changing password for remote distributor (distributor_admin)

Question

We have inherited a remote distribution db where the password has been lost.  I would like to confirm that if you change the password in the distributor properties-->publishers--> administrative link password that the password will be changed on all publishers without having to resnap the publications?

Answer 1

Hi DBAFan2013,

To change the password for a remote Distributor, please perform the following steps.

1.At the Distributor on the distribution database, execute sp_changedistributor_password, specifying the new password for this login for @password.

2.At every Publisher that uses this remote Distributor, execute sp_changedistributor_password, specifying the password from step 1 for @password.

In other words, you also need to change password on all the remote Publisher servers after changing the password in the distributor properties.

Reference:
How to: View and Modify Replication Security Settings (Replication Transact-SQL Programming)
Error messages and the solutions related to “distributor_admin” login

Thanks,
Lydia Zhang

If you have any feedback on our support, please click here.

---

Lydia Zhang
TechNet Community Support

Answer 2

You will need to change the password on every publisher but you will not be forced to regenerate the snapshot.

---

looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941