SetUpDistributorPassword Method
The SetUpDistributorPassword method changes the password for the distributor_admin login.
Applies To
| Distributor Object |
Syntax
object.SetUpDistributorPassword( bstrName )
Parts
object
Expression that evaluates to an object in the Applies To list
bstrName
String that specifies a Microsoft® SQL Server™ 2000 password
Prototype (C/C++)
HRESULT SetUpDistributorPassword(SQLDMO_LPCSTR pszPassword);
Remarks
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 Connecting to the Distributor.
Changing a Distributor password using the SetUpDistributorPassword method requires appropriate permissions. The SQL Server login used for SQLServer object connection must be a member of the fixed role sysadmin on the Publisher.