Microsoft SQL® database for Watchdoc - Presentation

Context

In Watchdoc, the printing activity is registered in a statistic database.

Furthermore, if your organisation does not have any dedicated directory (Active Directory), a directory can be created in a MS SQL^® database.

Last, it's on a MS SQL^® database that the Guests directory (Guests database) is built. This database allows to manage users who are not present in the organization's directory.

It is then necessary to create a dababase before the Watchdoc installation.

Furthermore, as the database evolves and data varies, query processing may slow down over time due to index fragmentation. To avoid this issue, we recommend that you regularly clean up your database by following the maintenance plan provided.

Prerequisites

Before installing the MS^® SQL database, ckeck the following prerequisites:

• the database is not a MS^® SQLExpress database;

• the MS^® SQL version is compatible with the Watchdoc version (cf. the Watchdoc prerequisites);

• the MS^® SQL Management Service tool is installed on the server (free downloadeable from the Microsoft^® site);

In the case that SQL server is remote (classical mode or remote mode), check that TCP/IP is activated in the SQL Server Configuration Manager.
Also check that the SQL Browser service is started, so that Watchdoc may display the available servers and instances list.
The TCP 1433 port must be open on the firewall for the instance.
The UDP 1434 port must be open on the SLQ Server Browser.

Download links

Choose the version corresponding to the language of the MS Windows server:

Microsoft® SQL Server® 2022 Express	EN	https://www.microsoft.com/en-us/download/details.aspx?id=104781	File Size: 4.1 MB Hard Disk Space 4.2 GB of Disk Space
Microsoft® SQL Server® 2019 Express	EN	https://www.microsoft.com/en-us/download/details.aspx?id=101064	File Size: 6.1 MB Hard Disk Space 4.2 GB of Disk Space
Microsoft SQL Express 2017 Express Advanced FRA	FR	https://download.microsoft.com/download/0/E/0/0E08C7E6-43C8-4FE6-8035-9E3E31163417/SQLEXPRADV_x64_FRA.exe
Microsoft SQL Express 2016 SP1	FR	https://download.microsoft.com/download/6/C/7/6C794848-6203-49BA-B4A8-C1F6D39E14B9/FRA/SQLEXPRADV_x64_FRA.exe
	US	https://download.microsoft.com/download/9/0/7/907AD35F-9F9C-43A5-9789-52470555DB90/ENU/SQLEXPRADV_x64_ENU.exe
Microsoft SQL Express 2014 SP2	FR	https://download.microsoft.com/download/9/3/5/935702D4-4BCC-4834-B522-450D2B2626AE/SQLEXPRADV_x64_FRA.exe
Microsoft SQL Express 2012 SP3	FR	https://www.microsoft.com/fr-FR/download/details.aspx?id=50003	version SQLEXPRADV_x64_FRA.exe 2 Go
	US	https://www.microsoft.com/en-my/download/details.aspx?id=50003	version SQLEXPRADV_x64_ENU.exe 1.9 Go