Configure VMware Horizon 6 Event Database and Reporting

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.

The following two tabs change content below.

• Bio
• Latest Posts

Bipin

Bipin is a freelance Network and System Engineer with expertise on Cisco, Juniper, Microsoft, VMware, and other technologies. You can hire him on UpWork. Bipin enjoys writing articles and tutorials related to Network technologies. Some of his certifications are, MCSE:Messaging, JNCIP-SEC, JNCIS-ENT, and others.

Latest posts by Bipin (see all)

• Install Exchange 2019 in Windows Server 2019 - November 28, 2020
• Why Backup your Microsoft Office 365 - November 27, 2020
• What’s New in VMware vSphere 7 - September 18, 2020