共用方式為


SetUpDistributorPassword Method

未來的 Microsoft SQL Server 版本將移除這項功能。請避免在新的開發工作中使用這項功能,並規劃修改目前使用這項功能的應用程式。

The SetUpDistributorPassword method changes the password for the distributor_admin login.

語法

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);

備註

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.

Applies To: