SQL Server Replication – Setup and configure a SQL Server 2000 as a main Publisher/Distributor – Part 2 of 4

01- Setup and configure Publisher -Distributor

Setup and configure Publisher -Distributor by www.varindersandhu.in

Click on the Configuring Publishing, subscribes and Distribution option then the Configuring Publishing and Distribution Wizard starts up.

02- Setup and configure Publisher -Distributor

Setup and configure Publisher -Distributor by www.varindersandhu.in

03- Setup and configure Publisher -Distributor

Setup and configure Publisher -Distributor by www.vatindersandhu.in

04- Setup and configure Publisher -Distributor

Setup and configure Publisher -Distributor by www.varindersandhu.in

Specify the UNC (Universal Naming Convention) path

05- Setup and configure Publisher -Distributor

Setup and configure Publisher -Distributor by www.varindersandhu.in

Select “No”- accepting default settings – and press next.

06- Setup and configure Publisher -Distributor

Setup and configure Publisher -Distributor – www.varindersandhu.in

07- Setup and configure Publisher -Distributor

Setup and configure Publisher -Distributor by www.varindersandhu.in

Successfully enabled…” message should appear.

08- Setup and configure Publisher -Distributor

Setup and configure Publisher -Distributor by www.varindersandhu.in

Notification that a “replication object” has been added to the console tree for this server in SQL Server Enterprise Manager

Close this screen and the following SQL Server properties screen.

09- Setup and configure Publisher -Distributor

Setup and configure Publisher -Distributor by www.varindersandhu.in

Now you can see the Publisher in SQL Server Enterprise Manager

Reference URL
http://www.varindersandhu.in/2011/08/12/sql-server-how-to-setup-sql-server-replication/