SetUpDistributorPassword Method
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The SetUpDistributorPassword method changes the password for the distributor_admin login.
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 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.