VMware Horizon View 7: Create Events Database [Part 3]

Part 3 of the series will be creating the Events database. Horizon View uses the events database as a repository to store logging information such as user connections. Microsoft SQL Server or Oracle database servers are supported. For my environment I will be using SQL Server 2014. This step can be skipped if you do not want to log these events.

vBoring Blog Series:

  1. VMware Horizon View 7: Deployment and Installation
  2. VMware Horizon View 7: Apply SSL Certificates
  3. VMware Horizon View 7: Create Events Database
  4. VMware Horizon View 7: Add Microsoft RDS Farm
  5. VMware Horizon View 7: Setup Remote Access through Security Server
  6. VMware Horizon View 7: Create Master Desktop Template
  7. VMware Horizon View 7: Automated Desktop Pool
  8. VMware Horizon View 7: Instant Clone Desktop Pool

Creating Events Database in SQL 2014:

First we need to create the database. Login to your SQL server, launch the SQL Server Management Studio, right click Database then click New Database:

Horizon View 7 - 1 Create New SQL Database

Give the database a name, I used ViewEvents so it can easily be identified:

Horizon View 7 - 2 Name the DB

On the Options page change the Recovery model to Simple then click Ok:

Horizon View 7 - 3 Set Recovery Mode to Simple

Let’s create the account View will use to connect. Drill down to Security, right click Logins then click New Login:

Horizon View 7 - 4 - New Login

On the General page enter a Login name, select SQL Server authentication and enter a password. Change the drop down menu of Default Database to the Database that we created above.

Note: View only SQL authentication is supported.

Horizon View 7 - 5 General on New Login

On User Mapping select the database we created above, give it db_owner permissions then click Ok:

Horizon View 7 - 6 User Mapping on New Login

Add Events Database in Horizon View 7:

Switch back over to the View Administrator Console, drill down to View Configuration -> Event Configuration -> then click Edit:

Horizon View 7 - 7 Event Configuration

Enter the FQDN/IP Address of your SQL Server, Database Name, and the Login created from above.

You would enter something in the Table Prefix if you were going to have multiple instances of View talking to the same database.

Click Ok:

Horizon View 7 - 8 Edit Event Database

The Event Database section should now be populated if the details you entered were correct. You can edit the Events Settings to change the time period settings, but I left them default.

Horizon View 7 - 9 Database Added

Browse to Monitoring -> Events. Here you will find a summary of recently added events.

Horizon View 7 - 10 Events Page

On the View Dashboard you will now see the Event Database section populated.

Log Insight - Events Database Setup

Proceed to the next step:

VMware Horizon View 7: Add Microsoft RDS Farm

Leave a Reply