Jaa


How to: View and Modify Distributor Properties (SQL Server Management Studio)

View and modify Distributor properties in the Distributor Properties - <Distributor> dialog box.

To view and modify Distributor properties

  1. Connect to the Distributor in Microsoft SQL Server Management Studio, and then expand the server node.

  2. Right-click the Replication folder, and then click Distributor Properties.

  3. View and modify properties in the Distributor Properties - <Distributor> dialog box.

    • To view and modify properties for a distribution database, click the properties button (...) for the database on the General page of the dialog box.
    • To view and modify Publisher properties associated with the Distributor, click the properties button (...) for the Publisher on the Publishers page of the dialog box. For information about accessing additional Publisher properties, see How to: View and Modify Publisher Properties (SQL Server Management Studio).
    • To access profiles for replication agents, click the Profile Defaults button on the General page of the dialog box. For more information, see Replication Agent Profiles.
    • To change the password for the account used when administrative stored procedures execute at the Publisher and update information at the Distributor, enter a new password in the Password and Confirm password boxes on the Publishers page of the dialog box. For more information, see Securing the Distributor.
  4. Modify any properties if necessary, and then click OK.

See Also

Concepts

Configuring Distribution

Other Resources

How to: View and Modify Publisher and Distributor Properties (Replication Transact-SQL Programming)

Help and Information

Getting SQL Server 2005 Assistance