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.

creating_view_composer_database1

creating_view_composer_database2

Now, you provide the name of the database and the required details as shown

creating_view_composer_database3

creating_view_composer_database4

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.

creating_view_composer_database_complete

Now, we create a new SQL user and assign that user to the above database.

creating_new_login_view_composer_database1

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

creating_new_login_view_composer_database2

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.

creating_new_login_view_composer_database3