VMware vCenter Server can be configured to store its event logs in a Microsoft SQL database. Collection from a Microsoft SQL database requires:
- Universal Database Log Adapter (UDLA) Log Source
- Requires a LogRhythm Agent to collect the logs
- Requires access to the Microsoft SQL database that VMware vCenter Server uses for storing event logs
Identify the following prior to configuration:
- The IP address and hostname of the Microsoft SQL Server Database server used by VMware vCenter Server.
- The account login and password to be used by LogRhythm for accessing the VMware vCenter Server log data in the SQL Server database.
- The LogRhythm System Monitor Agent that will be used to collect the logs from VMware vCenter Server.
Configure VMware vCenter Server - Events
Make available an account that the LogRhythm Agent will use to access the Microsoft SQL database. We recommend using or creating an account that has read-only access into the tables required for collection.
Configure the ODBC Driver for VMware vCenter - Events
LogRhythm accesses VMware vCenter Server logs via an ODBC driver. Before configuring the UDLA log source in LogRhythm, the recommended driver must already be installed on the System Monitor host and configured according to the information in Configure UDLA Log Collection.
Name. SQL Server
Company Name. Microsoft Corporation
Download Location. Pre-installed
After you configure the device, you must also configure LogRhythm according to the instructions provided on the overview page of this guide. You must use a LogRhythm System Monitor to collect the logs. The System Monitor does not need to reside on the VMware vCenter Server server, but it must be able to establish a network ODBC (Open Database Connectivity) connection.
Only Global Admins or Restricted Admins with elevated View and Manage privileges can take this action.
Before you begin, download the VMware vCenter Server Events XML configuration file. You will import this file later to populate the UDLA configuration fields for the Log Source.
The name of the log message source is UDLA – VMware vCenter Server. In addition, when configuring this log source:
- For Log Message Processing Mode, select MPE Processing Enabled, Event Forwarding Enabled.
- For Log Message Processing Engine (MPE) Policy, select LogRhythm Default.
- On the UDLA Settings tab, enter the following:
Click Import, and then browse to and open the XML file that you downloaded from LogRhythm.
In the Connection String box, you will need to replace vCenter with the data source name.
- If you want to validate the current settings, click Test.
If the test fails, verify the connection settings and that all values were entered correctly.
- When the test passes, close the Test dialog box.