Watchdoc registers statistics and the users's Virtual Purses in two databases. Compatible Database servers are the following:

• MS SQL Server^® (Express/Standard/Enterprise) 2012, 2014 or 2016, 2017 and 2019 with following prerequisites:

  • Mixed mode;

  • SQL browser (if remote SQL with a named instance).

  • the language used must be Case Insensitive (e.g. French_CI_AS).

     

If the SQL server is remote (in classic or remote modes), make sure that TCP/IP is enabled in SQL Server Configuration Manager.

Also make sure the SQL Browser service is started so that Watchdoc can display the list of servers and available instances.

• PostgreSQL^® 17 (N.B.: Doxense^® does not offer any assistance with settings).

• In the case of using Report Services for Watchdoc (WRS) (to generate comprehensive printing activity reports), Reporting Services (included in MS SQL Server min. of SQL: 2008 R2) must be installed.

• SQLite^®: Watchdoc is compatible with SQLite distributed in the Watchdoc installation package. As SQLite functions as a local database, it is only recommended for small configurations or on servers in a domain that send their data to the SQL database on the master server.