VMware Horizon View – Setup DB for EventsDB

Welcome to my VMware Horizon View series, how I setup “View” in my LAB. In this session I will describe how I did the  preparations for the Events Database used by VMware Horizon View Connection Server. For this database I will be using my existing MS SQL Database server.

 

I login to the db-server, start “SQL Management Studio”. Right-click on SQL Server on the top, choose “Properties”

sql-conf01

 

From the “Security”-page, choose “SQL Server and Windows Authentication Mode”, OK

sql-conf02

 

Right-click Databases – New Database

sql-conf03

 

Give the database a name, in this case this will be the Events-database for the Connection-server, so I’ll call it EventsDB

sql-conf04

 

The new database is now present under Databases-folder.

sql-conf05

 

Now we will setup sql-permissions for the EventsDB-database, right-click Logins – New Login…

sql-conf06

 

I will create a sql-user: viewadmin, be sure to uncheck “Enforce password policy”

sql-conf07

 

The Server Role “Public” will be sufficient for my viewadmin-user

sql-conf09

 

I map my user to my newly created EventsDB-database and give the user db_owner membership for this database.

sql-conf09

sql-conf10

 

Be sure to grant permission to connect and login to database is selected.

sql-conf11

 

Recommended reading:

Paolo Valsecchi has written an excellent write-up about this topic, posted here:

https://nolabnoparty.com/en/vmware-horizon-7-view-event-database-configuration/

 

VMware Horizon View planning, deployment etc.

 

Disclaimer: Every tips/tricks/posting I have published here, is tried and tested in different it-solutions. It is not guaranteed to work everywhere, but is meant as a tip for other users out there. Remember, Google is your friend and don’t be afraid to steal with pride! Feel free to comment below as needed.