Horizon View 7

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

Part 2: Install and Configure View Connection Server 7

Part3:Install and Configure View Composer

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

creating_new_login_view_composer_database4

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

creating_events_database1

creating_events_database2

we click OK for the database to be created.

Now, we create a user for the events database

creating_events_database_loginuser1

creating_events_database_loginuser2

creating_events_database_loginuser3

creating_events_database_loginuser4

creating_events_database_loginuser_complete

In the next part, we will see how to Install and Configure View Connection Server 7

Part 2: Install and Configure Connection Server

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s