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.
Enter the Database name and click OK.
Right click Logins under Security and select New Login.
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.
Access the User Mapping field, map the database and assign the db_owner role to the new user.
In Status field make sure the user is enabled to login. Click OK.
The new user has been created successfully.
In Server Properties under Security, double check that SQL Server and Windows Authentication mode is enable. Click OK.
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.
For all IP addresses set the TCP/IP Port with value 1433 then click OK.
You need to restart the SQL service to make changes active. Click OK.
Select SQL Server Services in the left side then right click SQL Server (SQLEPXPRESS). Select Restart to restart the service.
Service is restarted.
Configure Event Database in Horizon
From the Horizon console, access the Event Configuration field and click Edit in the Event Database area.
Specify the requested parameters:
- DNS name or IP address of the Database server
- User name using the SQL Server Authentication
- Table prefix
Click OK to connect the database.
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.
When the database is connected, the connection details are displayed in the Event Database area.
The System Health area in the Dashboard shows the connected DB server and all components are now with a green icon.
The logs are available in Events under Monitoring.
The Event Database makes logs more clear and detailed with a clean view useful especially during troubleshooting.