The SetUpDistributorPassword method changes the password for the distributor_admin login.
object.SetUpDistributorPassword( bstrName )
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
| bstrName | String specifying a Microsoft® SQL Server™ password |
The distributor_admin login is used by a publisher, including a local publisher, when connecting to a distributor. For more information about the distributor_admin login, see Distributor Administrative Link Security.
Changing a Distributor password by using the SetUpDistributorPassword method requires appropriate privilege. The SQL Server login used for SQLServer object connection must be a member of the fixed role sysadmin on the Publisher.
HRESULT SetUpDistributorPassword(SQLDMO_LPCSTR pszPassword);