Documentation for Auto Intellect 5.6. Documentation for other versions of Intellect is available too.

Previous page Example of setting up the Traffic replication database  Setting up replication on the subscriber server Next page


To set up the replication do the following operations on every server, publishing the data:

  1. Run the utility Sql Server Configuration Manager (for this select on the taskbar: Start -> Programs->Microsoft SQL Server 2008-> Configuration Tools-> SQL Server Configuration Manager).
  2. The utility window Sql Server Configuration Manager will open in result.
  3. On the left part of the Sql Server Configuration Manager utility select the value SQL Server Services (1).
  4. SQL Server service will be displayed on the right part of the window in result. It is necessary to check whether the Sql Server Agent (MSSQLSERVER) service is run:
    1. In case when the Sql Server Agent (MSSQLSERVER) is run there will be Running value in the column State (2).
    2. In case when the Sql Server Agent (MSSQLSERVER) is not run, run it by clicking the Play button on the upper control panel (3).
  5. Sql Server Agent (MSSQLSERVER) service can be configured for auto run of the server or may be run manually. To set the auto run parameters do the following:
    1. Give a right click upon the Sql Server Agent (MSSQLSERVER) service.
    2. Select the Features point in the opened contextual window.
    3. Features: Sql Server Agent (MSSQLSERVER) window will open in result.
    4. Go to the Service tab (1).
    5. From the dropdown list of the Start Mode parameter select the Automatic value (2).
    6. Click Ok to save the changes (3).
    7. The Start Mode parameter was named as Automatic in result (4).
  6. Run the Microsoft Sql Server Management Studio utility and after connecting to the data publishing server open the server node (1).
  7. Open the Replication folder (2), and then make a right click upon the Local Publication folder (3).
  8. Select the New Publication point in the opened contextual menu.
  9. New Publication Wizard will be displayed in result.
  10. Following the wizard's instructions New Publication Wizard, enter the following information about the publication:
    1. Select the distributor database from the Databases list (1).
    2. Click Next to continue (2).
    3. Select the type value of the publication that is being created from the Publication Type - Merge publication list (1).
    4. Click Next to continue (2).
    5. State the subscriber type, setting the Sql Server 2008 checkbox (1).
    6. Click Next to continue (2).
    7. State the database objects to be included into publication, setting the Tables checkbox (1).
    8. Click Next to continue (2).
    9. Do not change next two tabs.
    10. Go to the Snapshot Agent tab Agent Security and click the Security settings button (1).
    11. Snapshot Agent Security window will open in result.
    12. Set the switch to the position Run under sql server Agent service account (This is not a recommended security best practice) (1).
    13. Click OK for saving the changes (2).
    14. On the Complete the wizard tab enter the publication name in the field Publication name (1).
    15. Click Finish to create a new publication (2).
    16. In the Creating Publication opened window there will be displayed the process of tasks performance while creating a new publication.
    17. Click Close to finish the New Publication Wizard operation.

Setting up the replication on the publishing server is completed.

  • No labels