共用方式為

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:

Distributor Object