Enable a Publisher to use a remote Distributor on the Publishers page. This page is available in the Configure Distribution Wizard and the Distributor Properties - <Distributor> dialog box. For more information about using the wizard and accessing the dialog box, see How to: Configure Distribution (SQL Server Management Studio) and How to: View and Modify Distributor Properties (SQL Server Management Studio).
To enable a Publisher in the Configure Distribution Wizard
-
On the Publishers page of the Configure Distribution Wizard, click Add.
-
Click Add SQL Server Publisher. For information about enabling an Oracle Publisher to use a Distributor, see How to: Create a Publication from an Oracle Database (SQL Server Management Studio).
-
In the Connect to Server dialog box, specify connection information for the Publisher that will use the remote Distributor, and then click Connect.
-
On the Distributor Password page, in the Password and Confirm password text boxes, specify a strong password for the distributor_admin account, which replication uses to connect from the Publisher to the Distributor to perform administrative tasks.
-
To view and modify settings for a Publisher, click the properties button (…).
-
Click OK.
To enable a Publisher in the Distributor Properties dialog box
-
On the Publishers page of the Distributor Properties - <Distributor> dialog box, click Add.
-
Click Add SQL Server Publisher. For information about enabling an Oracle Publisher to use a Distributor, see How to: Create a Publication from an Oracle Database (SQL Server Management Studio).
-
In the Connect to Server dialog box, specify connection information for the Publisher that will use the remote Distributor, and then click Connect.
-
On the Publishers page, in the Password and Confirm password text boxes, specify a strong password for the distributor_admin account, which replication uses to connect from the Publisher to the Distributor to perform administrative tasks.
-
To view and modify settings for a Publisher, click the properties button (…).
-
Click OK.
Concepts
Configuring Distribution
Securing the Distributor
Setting Logins and Passwords When Configuring the Distributor
Other Resources
How to: Configure Publishing and Distribution (Replication Transact-SQL Programming)
Help and Information
Getting SQL Server 2005 Assistance