Database - Configuring a MS SQL® database in Watchdoc

Access the configuration interface

When Watchdoc is installed, the shortcut to administration interface is created on the web server (IIS) desktop.

 

  1. From the web server (IIS) desktop in Watchdoc:

  2. Click on the shortcut Watchdoc Administration;

  3. Authenticate yourself in the Watchdoc web interface by entering the password set up in the options during installation (changeme by default) (refer to Installing Watchdoc in Standalone or Classic mode),

  4. Click on :


     

  1. You will access the Main menu in the Watchdoc administration interface.

Configuring the new statistics database

From the Main menu, Configuration section, click on Advanced Configuration;

  1. in the Advanced configuration interface, click on Statistics database;

  2. in the Statistics section, click on the Edit database settings... button;

  3. you will access the Connection settings for the statistics database, Statistics section,

 

  1. in the Database field, enter the new created database name;

  2. click on the Check the database button, so that Watchdoc® may check the connection;

  3. when the database is correctly configured, a message confirms it;

  4. click on the Validate button to confirm the configuration:

è the statistics pages and the balance sheets are then calculated on the restored database.

Importing the external queues

Principle

The purpose of this last procedure is to integrate into the Watchdoc® configuration file the organisation controlled queues (name, driver, …).

To perform this opération, you can use the createextenal.vbs script which relies on 2 components:

source: the organisation configuration file;

destination: the Watchdoc® configuration file.

Procedure

  1. In the server where Watchdoc® is installed, create a temporary folder (c:\temp);

  2. save the script and the config.xml configuration file in the c:\temp folder;

  3. launch a command line and enter the following script:

    c:\temp\createexternal.vbs –s c:\temp\config.xml –d c:\program files\doxense\Watchdoc\Data\config.xml

  4. restart the Watchdoc service to take into account the changes.