Introduction
VMware Horizon records events like administrator actions, end-user actions, system failures and errors etc. You can either leverage Microsoft SQL or Oracle Database for recording events. Before proceeding to configure VMware Horizon to log events, In this post, we will be covering the steps to create a Microsoft SQL database. You do not need to create an ODBC data source for this database.
Demo
Procedure
Install SQL Server & SQL Server Management Studio in Mixed Mode authentication
Login to SQL Server Management Studio. Click on New Database
Give the database name and click on OK.
Create a new login account and assign DB Owner permission to the new database
Select “SQL Server Authentication” & Uncheck “User must change password at next login” & Click OK.
Click on User Mapping. Select new database & check db_owner.
Start “SQL Server configuration manager”. Go to “SQL Server Network configuration” then protocols for SQLEXPRESS. Enable TCP/IP if disabled. Click on Properties.
Restart the SQL Services
Conclusion
This concludes the steps required to create and configure SQL Server database before configuring it as VMware Horizon Event Database. Hope this will be informative for you. Thanks for Reading!!!. Be social and share if you find worth reading it.