Documentation for Auto PSIM 1.0.1.

Previous page Setting up the replication on the publishing server  Appendix 4. Procedures for the Auto PSIM database and software for fine imposing interaction Next page

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

  1. Run Sql Server Configuration Manager (For this select on the taskbar: Start -> Programs -> Microsoft SQL Server 2008 -> Configuration Tools -> SQL Server Configuration Manager).
  2. Make sure, that SQL Server 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 Sql Server Management Studio utility and after connection to the subscription server open the server's node (1).
  4. Open the Replication folder (2) and then make a right click upon the Local Subscriptions folder (3).
  5. Select the New Subscriptions point in the opened contextual menu.
  6. New Subscription Wizard will be displayed in result.

  7. Select the publication server from the Publisher dropdown list (1).

    Note.

    Id the publication server is absent in the list one should find it with the help of Find SQL Server Publisher function.


  8. In the objects tree Databases and publication select the publication (1).
  9. Click Next to continue (2).
  10. Leave the parameter Merge Agent Location unchanged.
  11. In the Subscribers window set the checkbox Subscriber next to subscriber (1).

  12. Select the subscription database from the Subscription Database dropdown list (1).

    Note.

    In case of connecting the first publishing server one should create a new subscription database, clicking the function <New database…>.


  13. To add SQL Server subscriber click the button Add SQL Server Subscriber… (2).
  14. Merge Agent Security window will open.
    1. Set the switch to the Run under SQL Server Agent service account (This is not recommended security best practice) position (1).
    2. Click Ok» to save the changes (2).
  15. Click Next to continue.
  16. For distributor agent constant operation select the value Run continuously from the Agent Schedule dropdown list in the Synchronization Schedule window (1).
  17. Click Next to continue (2).
  18. In the Initialize Subscription window the following should be done:
    1. Set the Initialize checkbox in case of adding the first publishing server (1).
    2. Uncheck the Initialize checkbox in case of adding the second and further servers (1).
  19. Click Next to continue (2).
  20. Select the Client subscription type from the dropdown list Subscription Type in the Subscription Type window (1).
  21. To end the creation of a new subscriber click Finish (2).
  22. In the Creating Publication opened window there will be displayed the process of creating a new subscriber.
  23. Click Close to end the process of New Subscription Wizard operation.

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

  • No labels