User manual

is also possible to use a Microsoft SQL server, which stores Avira AntiVir Exchange data
in an SQL database. The supported databases include MS SQL Server 2000 and MS
SQL Server 2005; in addition, MS SQL Server 2005 Express can be used with restricted
CPU/memory capacity.
When to use SQL servers
A Microsoft SQL server could be used in multi-server environments without server
synchronization in order to ensure that each user receives a single central whitelist only
for all servers involved.
A Microsoft SQL server could also be used for Quarantine databases.
If multiple SQL servers as well as multiple Avira AntiVir Exchange servers are installed in
a multi-server environments, the servers can be arranged in pairs. This means that a
local SQL server is installed on each Avira AntiVir Exchange server and therefore only
one database connection needs to be set up.
Note: Please note that Avira AntiVir Exchange is optimized for being used as a
local database based on the MS Jet Engine. Complex server environments require
a number of configurations of both Avira AntiVir Exchange and MS SQL Server,
which go beyond the scope of this document. Please contact our Support for
details.
Configuration of the Database Connection
The following sections describe the configuration of database connections between Avira
AntiVir Exchange and a Microsoft SQL server. Please note that a distinction is made
between a central MS SQL server for central user whitelists and a local MS SQL server
for the Quarantine.
SQL Server and Avira AntiVir Exchange Server
If SQL Server and Avira AntiVir Exchange Server are installed on the same computer, the
following must be met:
• The installations of SQL Server and Avira AntiVir Exchange Server are complete
• The database(s) have been set up and the corresponding tables created
• At least one user is defined as database user
• This database user has sufficient rights to the database
• The ADO driver has been installed on the Avira AntiVir Exchange server
If SQL Server and Avira AntiVir Exchange Server are installed on different systems, the
following has to be additionally ensured:
• The protocol set on the SQL server meets the requirements for external server
operation.
• The service has been restarted after completing the SQL Server configuration.
The database connection between Avira AntiVir Exchange and the SQL server is
established through the ADO protocol.
1. Under Basic Configuration - General Settings - Database Connections create a
new database connection.
2. Assign a Name for the connection configuration
3. Enter the ADO string information in the Connection stringfield.
4. Enter the required values manually or use the Avira AntiVir Exchange variables
available (Server, Catalog, etc.), which will be replaced with appropriate values at
runtime.
Avira AntiVir Exchange 7
47