Changing password of distributor_admin user

_{Wednesday, September 10, 2014 11:59 AM}

Hi All,

I just want to change the password of "distributor_admin" user 
can anyone suggest what are the pros and cons 
and also which is the better way to caange this password

_{Wednesday, September 10, 2014 12:13 PM ✅Answered}

I hope that this article will give you the answer as well as the correct way to change the "distributor_admin" password.

http://msdn.microsoft.com/en-IN/library/ms151735.aspx

New post on SQL Azure Forum.

_{Wednesday, September 10, 2014 4:37 PM ✅Answered}

Use the sp_changedistributor_password stored procedure, Distributor Properties dialog, or the Update Replication Passwords dialog to change the password for distributor_admin.  This way the password change will be applied to local publication automatically.

Brandon Williams (blog | linkedin)

_{Thursday, September 11, 2014 11:54 AM ✅Answered}

I did not get this point in my senario 

I have Publisher and distributor on same server 
and subscriber in different server  can you give an example

Hi ImranKazi,

In your scenario, you can use one the following options to change the password of "distributor_admin" on the distributor server .

1. Execute the T-SQL below.

USE master
EXEC sp_changedistributor_password 'newpassword'
GO

 2. In Object Explorer, right click on the Replication folder and click Distributor Properties, then change the Distributor_Admin password as shown in the below figure:

3. In Object Explorer, right click on the Replication folder and click Update Replication Passwords, then change the Distributor_Admin password as shown in the below figure:

When Publisher and Distributor are on different servers, you can review this similar blog to change the Distributor_Admin password.

Thanks,
Lydia Zhang

_{Wednesday, September 10, 2014 6:35 PM}

Also note that if you are using a remote distributor that you may need to update the password at any remote publishers.

Brandon Williams (blog | linkedin)

_{Thursday, September 11, 2014 5:24 AM}

Also note that if you are using a remote distributor that you may need to update the password at any remote publishers.

Brandon Williams (blog | linkedin)

I did not get this point in my senario 

I have Publisher and distributor on same server 
and subscriber in different server  can you give an example

_{Friday, September 12, 2014 5:58 AM}

special thanks to Lydia Zhang