6.0

Configure the Event Database
The event database stores information about View events as records in a database rather than in a log file.
You configure an event database after installing a View Connection Server instance. You need to configure
only one host in a View Connection Server group. The remaining hosts in the group are configured
automatically.
NOTE The security of the database connection between the View Connection Server instance and an
external database is the responsibility of the administrator, although event traffic is limited to information
about the health of the View environment. If you want to take extra precautions, you can secure this channel
through IPSec or other means, or you can deploy the database locally on the View Connection Server
computer.
You can use Microsoft SQL Server or Oracle database reporting tools to examine events in the database
tables. For more information, see the View Integration document.
You can also generate View events in Syslog format so that the event data can be accessible to third-party
analytics software. You use the vdmadmin command with the -I option to record View event messages in
Syslog format in event log files. See "Generating View Event Log Messages in Syslog Format Using the -I
Option" in the View Administration document.
Prerequisites
You need the following information to configure an event database:
n
The DNS name or IP address of the database server.
n
The type of database server: Microsoft SQL Server or Oracle.
n
The port number that is used to access the database server. The default is 1521 for Oracle and 1433 for
SQL Server. For SQL Server, if the database server is a named instance or if you use SQL Server
Express, you might need to determine the port number. See the Microsoft KB article about connecting
to a named instance of SQL Server, at http://support.microsoft.com/kb/265808.
n
The name of the event database that you created on the database server. See “Add a Database and
Database User for View Events,” on page 107.
For an Oracle 11g or 10g database, you must use the Oracle System Identifier (SID) as the database
name when you configure the event database in View Administrator.
n
The username and password of the user you created for this database. See “Add a Database and
Database User for View Events,” on page 107.
Use SQL Server Authentication for this user. Do not use the Integrated Windows Authentication
security model method of authentication.
n
A prefix for the tables in the event database, for example, VE_. The prefix enables the database to be
shared among View installations.
NOTE You must enter characters that are valid for the database software you are using. The syntax of
the prefix is not checked when you complete the dialog box. If you enter characters that are not valid
for the database software you are using, an error occurs when View Connection Server attempts to
connect to the database server. The log file indicates all errors, including this error and any others
returned from the database server if the database name is invalid.
Procedure
1 In View Administrator, select View Configuration > Event Configuration.
2 In the Event Database section, click Edit, enter the information in the fields provided, and click OK.
Chapter 8 Configuring Event Reporting
VMware, Inc. 109