Avira antivir exchange User Manual
Details on the Avira AntiVir Exchange Management Console
47
•
Initial Catalog=[DBCatalog];
Obligatory parameter that specifies
the database to be used. Enter the parameter ’Initial Catalog=’ in the
string manually and set the Avira AntiVir Exchange variable
string manually and set the Avira AntiVir Exchange variable
Database. If you
use the SQL server for the quarantine, the variable [DBCatalog] is replaced
with the name of the
with the name of the
database defined under Quarantine - Properties in the
Folder name field. If, on the other hand, you use the SQL server for a central
whitelist, the variable [DBCatalog] is replaced with the fixed name
’Whitelist’
whitelist, the variable [DBCatalog] is replaced with the fixed name
’Whitelist’
. The variable [DBCatalog] enables you to use a database
connection for several databases within an MS SQL server. Please note that the
databases must be created under precisely this name. Otherwise a connection
cannot be established.
cannot be established.
•
Data Source=LOCALHOST\SQLEXPRESS;
Obligatory parameter for a
locally installed MS SQL Server 2005 Express. In this case, enter the parameter
’Data Source=’
’Data Source=’
manually and, if necessary, set the Avira AntiVir Exchange
variable
Server. The [Server] variable is replaced by the NetBiosName of the
server at runtime. If you work in complex server environments with
subdomains, you can also use the Avira AntiVir Exchange
subdomains, you can also use the Avira AntiVir Exchange
Server (network)
variable. In this case, the [ServerFQDN] variable is set and the FQDN (Fully
Qualified Domain Name) of the server is read out. If the SQL server is used for
central whitelists, manually enter the name of the central SQL server here.
Qualified Domain Name) of the server is read out. If the SQL server is used for
central whitelists, manually enter the name of the central SQL server here.
Exception: In the case of a central SQL server, e.g. when the SQL server is used for
central whitelists, the two Avira AntiVir Exchange variables
central whitelists, the two Avira AntiVir Exchange variables
Server and Server
(network) cannot be used in the ADO string. Instead you should enter the name of the
SQL server manually, i.e. Data-Source=Name_des_Servers;
SQL server manually, i.e. Data-Source=Name_des_Servers;
4. Enter the name of the SQL user permitted to access the database in the
Database user
field (shown in the graphic as User). Enter the associated
Password in the next field.
The values entered here can be read out using the variables [ADOUser] and
[ADOPwd]
[ADOPwd]
in the ADO string.
5. The
Command Timeout field is used to specify the waiting period in seconds before
the database connection is closed if the database does not return data. You are advised
to begin with a value of 60 seconds when using large databases.
Configuring central whitelists
If the email is handled in multi-server environments, every server creates its own user
whitelists. Without server synchronization, each user therefore receives a separate whitelist for
whitelists. Without server synchronization, each user therefore receives a separate whitelist for
each participating server and each whitelist has to be maintained separately. To be able to
administer these whitelists centrally, thus simplifying administration, instead of the regular
local database based on Microsoft Jet-Engine, you can also set up a Microsoft SQL server to save
the data for all participating Avira AntiVir Exchange Servers in a central SQL database.
To configure central whitelists, you must first configure a database connection between the SQL
administer these whitelists centrally, thus simplifying administration, instead of the regular
local database based on Microsoft Jet-Engine, you can also set up a Microsoft SQL server to save
the data for all participating Avira AntiVir Exchange Servers in a central SQL database.
To configure central whitelists, you must first configure a database connection between the SQL
server and the Avira AntiVir Exchange Server. More settings are required within Avira AntiVir
Exchange after this, so that Avira AntiVir Exchange can use the entries from the whitelist
database.
The configuration of the database connection depends on the server environment
Exchange after this, so that Avira AntiVir Exchange can use the entries from the whitelist
database.
The configuration of the database connection depends on the server environment
2. Enter the central SQL server under Data Source=.
Note: Bear in mind that the [DBCatalog] variable for the whitelist database is
replaced with the fixed database name in the ADO string of the database connection.
replaced with the fixed database name in the ADO string of the database connection.