| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sp_changedistributor_password (Transact-SQL) |
Changes the password for a Distributor. |
markingmyname |
maghan |
randolphwest |
06/08/2023 |
sql |
replication |
reference |
|
|
|
[!INCLUDE SQL Server SQL MI]
Changes the password for a Distributor. This stored procedure is executed at the Distributor on any database. If this is a remote Distributor, then it needs to be run on all the Publisher servers that are using this Distributor. If the distribution or Publisher database is in an availability group, then it needs to be run on all the Distributor and Publisher nodes. It doesn't matter if the node is primary or secondary.
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
sp_changedistributor_password [ @password = ] 'password'
[ ; ]
The new password. @password is sysname, with no default. If the Distributor is local, the password of the distributor_admin system login is changed.
0 (success) or 1 (failure).
sp_changedistributor_password is used in all types of replication.
:::code language="sql" source="../replication/codesnippet/tsql/sp-changedistributor-pas_1.sql":::
Only members of the sysadmin fixed server role can execute sp_changedistributor_password.