Event monitoring and reporting is critical part of VMware Horizon View infrastructure. You can use existing or dedicated database to store View events. The database server can reside on same View Connection virtual machine, or can be on dedicated database server. You can also use Syslog to send event logs to Syslog server In this post, I will show steps to configure VMware Horizon 6 Event Database and Reporting.
Configure VMware Horizon 6 Event Database and Reporting
The diagram below shows the environment that we have been working on. SQL Server 2012 is already installed in DB01 virtual machine running Server 2012 R2.
So now, all we have to do is, create new database for View Events and call the database in View Admin. You don’t have to create ODBC database connection for this database. This step is usually done after installing View Connection server.
Log on to SQL server. Open SQL Server management studio. Right-click server and click Properties. In the Security page, make sure SQL Server and Windows Authentication mode is selected as Server Authentication. Click OK.
Right-click databases and click create new database.
Give a name for the database and click OK.
Now create new user that will connect to this database.
Type login name, I will type ViewEvent as username too.
Select Server Roles in the left pane. Under server roles, check public and sysadmin.
Select User Mapping on the left pane. Check ViewEvent database under Users mapped to this login. Check db_owner and public as database role membership. Click OK.
Now login to View Connection server. Expand View Configuration and click Event Configuration. Click Edit as shown below.
Type database information as shown below. Click OK.
The database will be added. You can view the details about the database as shown below.
The database has been added. Now events will be stored in the database.