Configuring VMware Horizon View Event Database

Horizon View 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. 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.  This post will guide you in configuring Horizon View event database.

Login to View administrator portal using the URL https://<IP or hostname of View connection server>/admin . Login with your View administrative credentials. Since Horizon view event database is not configured, you can notice yellow warning for event database.

Configuring Horizon view event database

Horizon view event database can be either Microsoft SQL server or Oracle. I have Microsoft SQL server database instance created for view event database.  Since i am using Microsoft SQL express edition, Ensure you have defined the port number under TCP\IP properties under SQL server network configuration in SQl server configuration manager.

Configuring Horizon view Event database_1-min Configuring Horizon view Event database_2-min

Configuring VMware Horizon View Event Database

In the VMWare Horizon View administrator, Click on Event Configuration under View configuration. Click on Edit under event database.

Configuring Horizon view Event database_3-min
You need the following information to configure an event database. Enter the below information and click on OK.

  • The DNS name or IP address of the database server.
  • Type of database server: Microsoft SQL Server or Oracle.
  • 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. We have defined the port number in the previous steps.
  • The name of the event database that you created on the database server.
  • The username and password of the user you created for this database.Use SQL Server Authentication for this user. Do not use the Integrated Windows Authentication security model method of authentication.
  • A prefix for the tables in the event database, for example, VE_ or event_. The prefix enables the database to be shared among View installations.

 

Configuring Horizon view Event database_4-min

Once Horizon View event database is configured, you will be able to see the event database information under event configuration.

Configuring Horizon view Event database_5-min

once Horizon view event database is configured, you will be able notice that events are logged under events in monitoring.

Configuring Horizon view Events database_6-min

That’s it. We are done with configuring Horizon view event database. I hope this is informative for you. Thanks for reading!!!. Be social and share it in social media like google+, facebook & twitter, if you feel worth sharing it.