VMware Horizon 7: View Event Database configuration

horizon7eventdb01

VMware Horizon uses the Event Database to store logs about View Manager events instead of storing data in a log file that is limited in information.

MS-SQL and Oracle are the supported databases to store the logs but in small environments the Event Database can be stored also in a MS SQL Express edition.

 

Create the Event Database

From Microsoft SQL Server Management Studio, right click Databases and select New Database.

horizon7eventdb02

Enter the Database name and click OK.

horizon7eventdb03

Right click Logins under Security and select New Login.

horizon7eventdb04

To access the Event Database from Horizon you should create a new user using SQL Server authentication. Specify a Login name and Password and disable the Enforce password policy option.

horizon7eventdb05

Access the User Mapping field, map the database and assign the db_owner role to the new user.

horizon7eventdb06

In Status field make sure the user is enabled to login. Click OK.

horizon7eventdb07

The new user has been created successfully.

horizon7eventdb08

In Server Properties under Security, double check that SQL Server and Windows Authentication mode is enable. Click OK.

horizon7eventdb09

 

Configure TCP Port

To configure the Event Database you need to know the port to connect to. Start the SQL Server Configuration Manager and under SQL Server Network Configuration select Protocols for SQLEXPRESS. Right click in the right pane the TCP/IP protocol and select Properties.

horizon7eventdb10

For all IP addresses set the TCP/IP Port with value 1433 then click OK.

horizon7eventdb11

You need to restart the SQL service to make changes active. Click OK.

horizon7eventdb12

Select SQL Server Services in the left side then right click SQL Server (SQLEPXPRESS). Select Restart to restart the service.

horizon7eventdb13

Service is restarted.

horizon7eventdb14

 

Configure Event Database in Horizon

From the Horizon console, access the Event Configuration field and click Edit in the Event Database area.

horizon7eventdb15

Specify the requested parameters:

  • DNS name or IP address of the Database server
  • Port
  • User name using the SQL Server Authentication
  • Password
  • Table prefix

Click OK to connect the database.

horizon7eventdb16

If you receive this error message, it means you have connection problems with the DB. Make sure SQL Server authentication option is selected and the Enforce password policy options  is disabled. Check if TCP Port field is populated with port 1433.

horizon7eventdb17

When the database is connected, the connection details are displayed in the Event Database area.

horizon7eventdb18

The System Health area in the Dashboard shows the connected DB server and all components are now with a green icon.

horizon7eventdb19

The logs are available in Events under Monitoring.

horizon7eventdb20

The Event Database makes logs more clear and detailed with a clean view useful especially during troubleshooting.

signature

One Response

  1. Arnaud S 26/07/2017

Leave a Reply