How to add or change a password on a Distributor

How to Install SQL Server 2000

How To

How to add or change a password on a Distributor

To add a password to a Distributor

  • Execute sp_add_distributor specifying the password parameter.

To change a password on a Distributor

  • Execute sp_changedistributor_password.