Create ODBC Connection for VMware Horizon View Composer Installation

VMware Horizon  has various components and View Composer is one of the optional components of VMware Horizon 6.   View Composer needs to be installed on the Windows Server on which vCenter Server is installed or on a separate Windows Server computer. View Composer requires an SQL database to store data. You need to create ODBC Connection between the SQL server and Server ,where View Composer is getting installed.  The View Composer database can be reside on the server as View Composer server host or in a remote database server. For Either of the DB server, you need to create ODBC connection. You might be having exitsing Database server for your vCenter Server. View Composer supports a subset of the database servers that vCenter Server supports. The View Composer database stores all the information about linked clone virtual desktops deployed by View Composer.  This article helps you to understand the Step by Step procedure to create ODBC Connection (DSN) for the View Composer installation.

Create ODBC Connection for VMware Horizon View Composer

Login to the Windows server where you are going to install View Composer and Open ODBC Data Source Administrator. Select System DSN tab and Click on Add.

Create ODBC Connection for Horizon View Composer Installation _2

Create New Data Source wizard will open. Click on SQL Server Native Client 10.0 or 11.0 and Click on Finish.

Create ODBC Connection for Horizon View Composer Installation _3

Type the name for the ODBC connection, description for the ODBC connection and SQL server IP address or Hostname. Click on Next.

Create ODBC Connection for Horizon View Composer Installation _4

There are two types of authentication. Windows NT authentication and  SQL server authentication.

Windows NT authentication : Select this option if you are using a local instance of SQL Server. This option is also known as trusted authentication. Windows NT authentication is supported only if SQL Server is running on the local computer.

SQL Server authentication: Select this option if you are using a remote instance of SQL Server. Windows NT authentication is not supported on remote SQL Server.

Since i am using the remote instance of MS SQL server, I have selected the option of SQL server authentication. Enter the Login ID and password for the SQL server authentication and click on Next.

Create ODBC Connection for Horizon View Composer Installation _5

Select the Check “Change the default database to ” and change the default database to View Composer database  instance ,which your SQL administrator created for View composer installation. Click on Next.

Create ODBC Connection for Horizon View Composer Installation _6

Review the ODBC connection settings and click on Finish.

Create ODBCConnection for Horizon View Composer Installation _7

Click on Test Data Source to test the Database connection.

Create ODBC Connection for Horizon View Composer Installation _8

You can see the message “Tests Completed Successfully”.  Click on Ok.

Create ODBC Connection for Horizon View Composer Installation _9We are done with configuring  ODBC Connection for the Horizon view Composer installation.  Next step is proceed with the  VMware Horizon 6.x – View Composer Installation. I hope this is informative for you. Thanks for Reading!!!. Be social and share it in social media like Google +, Facebook and Twitter , if you feel worth sharing it.