Skip to main content
Older versions of Internet Explorer will not support certain site features. Chrome, Safari, Firefox, and Edge will provide the best experience.
Spok

Adding the Workstation to the SQL Replication Push

  1. From the workstation, use Remote Desktop to connect to the database server . Use the Windows username credentials to log into the server.
  2. Open the Microsoft SQL Server Management Studio and click Connect. Username and password fields for the database are already auto-filled.
  3. Expand the database server in Object Explorer.
  4. Expand the Replication folder.
  5. Expand the Local Publications folder.
  6. Right-click XtendConsoleReplicated and select New Subscriptions.
  7. In the New Subscription Wizard, click Next.
  8. On the Publication page, leave default item as XtendConsoleReplicated and click Next.
  9. On the Distribution Agent Location page, select the option Run all agents at the Distributor and click Next.
  10. Click Add Subscriber and select Add SQL Server Subscriber.
  11. In the Server name field, enter the name of the workstation.
  12. From the Authentication drop-down list, select SQL Server Authentication.
  13. In the Login field, enter xnadmin.
  14. In the Password field, enter xtdsql.
  15. Click Connect.
  16. On the Subscribers page, the workstation is in the list and selected.
  17. From the Subscription Database drop-down list, select XtendConsole.
  18. Click Next.
  19. On the Distribution Agent Security page in the Subscription Properties area, click the ellipsis button (...) at the left end of the row containing the workstation's name. The Distribution Agent Security dialog displays.
  20. On the Distribution Agent Security dialog, select the Run under the SQL Server Agent service account option.
  21. In the Connect to Subscriber area, select the Using the following SQL Server login option.
  22. In the Login field, enter xnadmin.
  23. In the Password field, enter xtdsql.
  24. In the Confirm Password field, enter xtdsql.
  25. Click OK.
  26. Click Next.
  27. On the Synchronization Schedule page, from the Agent Schedule drop-down list and select <Define schedule>.
  28. In the New Job Schedule dialog, complete the following:

    1. In the Frequency area:
      1. From the Occurs drop-down list, select Daily.
      2. In the Recurs every field, select 1 day(s).
    2. In the Daily frequency area:
      1. In the Occurs once at field, use next time available from list – these are set every 5 minutes. If a workstation is replaced or re-imaged, reuse the original time from the list provided.
    3. In the Duration area: 
      1. From the Start date calendar, select the current date.
      2. Select the No end date option.
    4. Click OK.
  29. Click Next.
  30. On the Initialize Subscriptions page, click Next.
  31. On the Wizard Actions page, select the Create the subscription(s) check box.
  32. Click Next.
  33. On the Complete the Wizard page, click Finish.
  34. The Action for Creating subscription and Starting the synchronization agent(s) should both return Success status.
  35. Click Close.
  36. Exit Microsoft SQL Server Management Studio.
  37. Close the Remote Desktop connection.

If the install process completes correctly and you encounter an error when trying to connect to the workstation, go to workstation, stop and start SQL services and try again.