VCP5-DT Objective 2.2–Configure VMware View Events Database

Objective 2.2 – Configure VMware View Events Database

For this objective I used the following resources

• VMware View Architecture Planning documentation
• VMware View Installation documentation
• Blog Post by Jason Langone “How to configure VMware View 4.5’s Event Database with SQL Express”

Knowledge

Explain the Purpose of the Events Database

The Event Database is used to record events that occur in your View environment. The following is a short list of the event types that are logged:

• End-user actions such as logging in and starting a desktop session
• Administrator actions such as adding entitlements and creating desktop pools
• Alerts that report system failures and errors
• Statistical sampling such as recording he maximum number of users over a 24-hour period

Identify Minimum Requirements for the Events Database

• The Event Database is supported on the same databases as View Composer, listed in Objective 1.1 Install View Composer located HERE.
• DNS name or IP address of the database server
• User account with required permissions to create a new database
• You do not need to create an ODBC data source for this database
• If using MS SQL, use SQL Server Authentication. Do not use Integrated Windows Authentication
• A prefix for the tables in the event database, for example, VE_. The prefix enables the database to be shared among View installations

Identify Which Database Server is Being Used (i.e., Oracle or SQL)

• The default port for Oracle is 1521
• The default port for MS SQL is 1433

If utilizing SQL Express refer to THIS excellent post by Jason Langone (blog / twitter) outlining how to configure the Event Database correctly.

Determine Port Number

Step 1 – Log into View Administrator:

Step 2 – Select “Event Configuration” under “View Configuration”. In the “Event Database” section in the right hand pane the “Port” number is displayed:

Configure the Events Database Settings

Step 1 – Log into View Administrator:

Step 2 – Select “Event Configuration” under “View Configuration”. In the “Event Settings” section in the right hand pane click “Edit”:

Step 3 – Select the new database settings for either “Show events in View Administrator for” and “Classify events as new for” or both:

Configure the Connection to the Event Database

Step 1 – Log into View Administrator:

Step 2 – Select “Event Configuration” under “View Configuration”. In the “Event Database” section in the right hand pane click “Edit”:

Step 3 – Edit the required fields within the properties dialog box. Click “OK” completed: