How do I install WebWatchBot on two or more machines that point to one SQL Server?

From WebWatchBotWiki
Jump to: navigation, search

You can install WebWatchBot on two or more machines and point them all at the same SQL Server instance.

You will need to rename each database so that you can have one or more concurrent WebWatchBot databases running on one SQL Server.

Here are the steps to take:

  1. Install your first instance of WebWatchBot. A database named “WebWatchBot” is created.
  2. Start WebWatchBot Manager
  3. Stop the WebWatchBot service: Tools -> Stop Service
  4. Rename the database, i.e. “WebWatchBot1”, “WebWatchBotProd”, etc.
  5. Change the connection string that WebWatchBot uses to connect to its database on SQL Server
    1. Open the registry editor: Start -> Run, “regedit”
    2. Navigate to: HKEY_LOCAL_MACHINE\SOFTWARE\ExclamationSoft\WebWatchBot\5.0\General
    3. Change the string value “CONNECTION_STRING”. For example, a connection string looks like: DRIVER=SQL Server;SERVER=MACHINENAME\SQLEXPRESS;Database=WebWatchBot;UID=wwb;PWD=wwb$1. Change the database name from “WebWatchBot” to “WebWatchBot1” (or the name you changed it to in SQL Server).
    4. Click OK and close the registry editor.
  6. Start WebWatchBot Manager – the database will be connected to. If it fails, go back and verify each step.
  7. Start the WebWatchBot service when prompted or select the menu options: Tools -> Start Service.
  8. Install your second instance of WebWatchBot. A database named “WebWatchBot” is created.
  9. Repeat for additional instances of WebWatchBot.