I am starting a new series on Installing and Configuring Horizon View 7 and to create new desktop pools. (If possible, will also do the new feature Instant Clone in Horizon View 7)
Here are all the links in the series —
Part 1: Creating View Composer and Event Databases
Before we go ahead with the Horizon View Connection Server Installation and Configuration, let us create the view composer and events databases in SQL server.
In my lab, I have a dedicated SQL server 2012 VM and I have configured both the databases with their own SQL logins.
First, we open the SQL Management Studio in the SQL VM, login into it with the required credentials and on the left pane, we right click on the Databases option, click on Create a new Database to start with creating a new database.
Now, you provide the name of the database and the required details as shown
In the options tab (in the above picture), I chose the Recovery model to be ‘Simple’ instead of Full which is by default. This doesn’t affect the performance of the database itself.
Now, we create a new SQL user and assign that user to the above database.
Click on Logins Folder under Security tab on the left pane, click on New Login option to start the process of creating a new user
NOTE: Keep in mind to deselect the option “Enforce password policy” when creating the user. This prevents the account password from being expired.
Once we select the default database to the view composer database (as shown in the above picture), we go to user mapping where we click on the Database ‘msdb’ and ‘view composer’ and select the role db_owner. This is so that all contents can be written to these databases and particular user can control the view composer database.
Once done, click on OK to create the new user for view composer database.
Creating Events Database and new user for Events Database
follow the same steps we performed for the view composer database to create the events database
we click OK for the database to be created.
Now, we create a user for the events database
In the next part, we will see how to Install and Configure View Connection Server 7