ESET REMOTE ADMINISTRATOR 4 Manual de instalación descargar pdf (Pagina 13)

2.2.3.4 Database types supported by ERA Server

By default, the program uses the Microsoft Access (Jet Database) engine. ERAS 4.0 also supports the following databases:

Microsoft SQL Server 2005

MySQL 5.0

Oracle 9i

The database type can be selected during the Advanced installation mode of ERAS. After the installation it is not possible

to change the database type directly from ERA, however, you can do so using the ERA Maintenance Tool .

NOTE: Microsoft Access database is not supported on Windows Server 2008 Core

2.2.3.4.1 Basic requirements

First, it is necessary to create the database on a database server. The ERAS installer is capable of creating an empty MySQL

database, which is automatically named ESETRADB.

By default, the installer automatically creates a new database. To create the database manually, select the option Export

Script. Make sure that the Create tables in the new database automatically option is deselected.

Collation Settings

Sorting will be realized according to the default settings of each database. It is required to activate CASE INSENSIVITY (CI).

To activate:

- For MS_SQL and MySQL a COLLATE must be set up with the CI activated

- For ORACLE a NLS_SORT must be set up with the CI activated

- For MS Access no action is required because CI is already activated

Character set

It is important to use the UNICODE character set (UTF-8 is recommended), especially when clients have specific locales or

if ERA itself is working in a localized version. If there is no plan for replication and all clients connect to the same server,

you can use the character set for the locale of ERA that you want to install.

2.2.3.4.2 Database connection setup

After a new database is created, you must specify connection parameters for the database server using one of two

options:

Using DSN (data source name)

To open DSN manually, open the OBCD

Date Source Administrator

(Click Start > Run – and type odbcad32.exe).

Example of a DSN connection:

DSN =ERASqlServer

Important: The use of the System DSN is recommended for ERA to work properly.

Directly, using a complete connection string

All required parameters must be specified – driver, server and name of database.

This is an example of a complete connection string for MS SQL Server:

Driver ={SQL Server}; Server =hostname; Database =ESETRADB

1 2 ... 8 9 10 11 12 13 14 15 16 17 18 ... 91 92

Sin comentarios

ESET REMOTE ADMINISTRATOR 4 Manual de instalación Pagina 13