Page History

To set up replication do the following on the subscription server, gathering data from all the publishing servers:

1. Run «Sql Sql Server Configuration Manager» Manager (For this select on the taskbar: «Start»  «Programs»  «Microsoft SQL Server 2008»  «Configuration Tools»  «SQL Server Configuration Manager» Start -> Programs -> Microsoft SQL Server 2008 -> Configuration Tools -> SQL Server Configuration Manager).
2. Make sure, that «SQL SQL Server Agent» Agent service is run and configured fro auto start (see section . Setting up the replication on the publishing server, points 3-5).
3. Run the «Microsoft Microsoft Sql Server Management Studio» Studio utility and after connection to the subscription server open the server's node (Fig. 10.3—12, 1).
4. Open the «Replication» Replication folder (Fig. 10.3—12, 2) and then make a right click upon the «Local Subscriptions» Local Subscriptions folder (Fig. 10.3—12, 3).
5. Select the «New Subscriptions» New Subscriptions point in the opened contextual menu.
   

...

1. Image Added
2. New Subscription Wizard

...

1. «New Subscription Wizard» will be displayed in result.

2. Select the publication server from the

   «Publisher»

   Publisher dropdown list (

   Fig. 10.3—13,

   1).

   Info
   title Note.
   Id the publication server is absent in the list one should find it with the help of

...

1. Find SQL Server

...

1. Publisher function.

...

1. Image Added

2. In the objects tree «Databases Databases and publication» publication select the publication (Fig. 10.3—14, 1).
   

...

1. Image Added
2. Click «Next» Next to continue (Fig. 10.3—14, 2).
3. Leave the parameter Merge Agent Location» Location unchanged.
4. In the «Subscribers» Subscribers window set the checkbox «Subscriber» Subscriber next to subscriber (Fig. 10.3—15, 1).
   

...

1. Image Added

1. Select the subscription database from the

   «Subscription Database»

   Subscription Database dropdown list (

   Fig. 10.3—16,

   1).

   Info
   title Note.
   In case of connecting the first publishing server one should create a new subscription database, clicking the function

...

1. <New database…>.

...

1. Image Added

2. To add SQL Server subscriber click the button «Add Add SQL Server Subscriber…» (Fig. 10.3—16, Subscriber… (2).
3. «Merge Merge Agent Security» Security window will open (Fig. 10.3—17).
   1. Set the switch to the «Run Run under SQL Server Agent service account (This is not recommended security best practice)» position (Fig. 10.3—17, 1).
   2. Click «Ok» Ok» to save the changes (Fig. 10.3—17, 2).
      

...

1. 1. Image Added
2. Click Next to continue.

...

1. Click «Next» to continue (Fig. 10.3—16).
2. For distributor agent constant operation select the value «Run continuously» Run continuously from the «Agent Schedule» Agent Schedule dropdown list in the «Synchronization Schedule» Synchronization Schedule window (Fig. 10.3—18, 1).
   

...

1. Image Added
2. Click Next

...

1. Click «Next» to continue (Fig. 10.3—18, 2).
2. In the «Initialize Subscription» Initialize Subscription window the following should be dondone:
   1. Set the «Initialize» Initialize checkbox in case of adding the first publishing server (Fig. 10.3—19, 1).
   2. Uncheck the «Initialize» Initialize checkbox in case of adding the second and further servers (Fig. 10.3—19, 1).
      

...

1. 1. Image Added
2. Click Next

...

1. Click «Next» to continue (Fig. 10.3—19, 2).
2. Select the «Client»subscription Client subscription type from the dropdown list «Subscription Type» Subscription Type in the «Subscription Type» Subscription Type window (Fig. 10.3—20, 1).
   

...

1. Image Added

1. To end the creation of a new subscriber click «Finish» (Fig. 10.3—20, Finish (2).
2. In the «Creating Publication» Creating Publication opened window there will be displayed the process of creating a new subscriber (Fig. 10.3—21)
3. Click «Close» Close to end the process of «New New Subscription Wizard» Wizard operation (Fig. 10.3—21).

...

1. 
   Image Added

...

Setting up the replication on subscriber's server, gathering data from all the publishing servers is completed.