Enable logging to an external MS SQL database

By default, Adaxes log records are stored in the SQLite database located on the computer where Adaxes service is running. Since SQLite databases are not replicated, each instance of Adaxes service has access only to its own log records. In a multi-server environment, it is recommended to store log records in an external MS SQL database so that each Adaxes service has access to all log records.

To configure Adaxes to store log records in an external Microsoft SQL database:

  1. Create a database in an on-premises Microsoft SQL Server or on a server outside your network (e.g. Windows Azure SQL).

  2. Specify a database owner. By default, the Adaxes service account will be used to connect to the database.

  3. Launch Adaxes Administration console.

  4. In the Console Tree, expand the Adaxes service node (the icon represents service nodes).

  5. Right-click Logging and then click Properties in the context menu.

  6. On the General tab, select External database (MS SQL).

  7. Specify the server name and the database to store log records.

  8. Specify the account whose credentials will be used to connect to the external database:

    • Click Authentication.
    • In the Mode drop-down, select SQL Server Authentication.
    • Specify the login and password of the required account. The account must be the owner of the external database.

Note

Log records generated while an external database is unavailable will not be lost. They will be retained in the local SQLite database and will be synchronized to the MS SQL database when it becomes available again. The retention period of locally stored log records can be changed. If the external database is unavailable when the retention period of an unsynchronized log record expires, the record will be permanently lost.

See also