title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | ms.custom | helpviewer_keywords | monikerRange | ||
---|---|---|---|---|---|---|---|---|---|---|---|---|
Enable remote Publisher at Distributor (SSMS) |
Learn how to enable a remote Publisher at the Distributor using SQL Server Management Studio (SSMS). |
MashaMSFT |
mathoma |
03/01/2017 |
sql |
replication |
ui-reference |
updatefrequency5 |
|
=azuresqldb-mi-current||>=sql-server-2016 |
[!INCLUDE SQL Server SQL MI] 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 Configure Publishing and Distribution and View and Modify Distributor and Publisher Properties.
-
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 Create a Publication from an Oracle Database.
-
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 (...).
-
Select OK.
-
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 Create a Publication from an Oracle Database.
-
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 (...).
-
Select OK.
Configure Publishing and Distribution
Configure Distribution
Secure the Distributor