Configuring the Event Database in VMware Horizon 8.11 (2309) is a crucial step when setting up a virtual desktop infrastructure. This event database configuration allows for better troubleshooting and monitoring of Horizon events, which can help administrators identify and resolve issues more efficiently. In this article, we will guide you through the process of configuring the Event Database in VMware Horizon 8.11 (2309).

Step 1: Open SQL Management Studio and Connect to the Database Server

To start, open SQL Management Studio on your computer and connect to the database server hosting the Event Database. This will allow you to manage and configure the Event Database settings.

Step 2: Create a New Database for Event Logging

Once connected to the database server, right-click on Database under the Object Explorer menu and select New Database. Define the name of your new Event Database, such as “VMware Horizon Events”. This will create a new database specifically for storing Horizon events.

Step 3: Set Recovery Mode to Simple

Next, right-click on the newly created Event Database and select Properties. Under the Options tab, set the Recovery Model to Simple. This will ensure that the Event Database can be recovered quickly in case of a failure or corruption. Click OK to save the changes.

Step 4: Create a New Login for the Event Database

Right-click on Logins under the Security menu and select New Login. Define the name of your new login, such as “VMware Horizon Events”, and select SQL Server authentication. Set a password for the login and ensure that it is strong and secure.

Step 5: Map Users to the Event Database Login

Under the User Mapping tab, set the Default Database to the newly created Event Database. Then, map users to this login with Event DB access. This will allow users to access and view event logs within the Horizon environment. Finally, set the Database role membership as DB Owner to grant full control over the Event Database to the new login. Click OK to save the changes.

Step 6: Configure Event Database Settings in Horizon Admin Console

From the Horizon Admin console, select Event Configuration under Settings. Select Edit and define the Database configuration. Click OK to save the changes.

Step 7: Set Event Retention Settings

Finally, click the Edit button below the Event Settings to change the event retentions. You can choose to retain events for a specific period or until the Event Database reaches a certain size. Once you have set your desired retention settings, click OK to save the changes.

With these steps, you have successfully configured the Event Database in VMware Horizon 8.11 (2309). This configuration is crucial for troubleshooting and monitoring issues within your virtual desktop infrastructure. By following this guide, you can ensure that your Event Database is properly set up and ready to capture and store events from your Horizon environment.