Setting up an ODBC connection for Horizon View Composer

Last week I set up VMware Horizon View 6 with View Composer etc and ran into an issue with setting up a proper ODBC connection for View Composer.

odbc connectionBefore actually setting up a new ODBC Data Source for VMware View Composer, you’ll need to create a user and password on your database server.

In my case, I used Microsoft SQL Server 2012 and used Microsoft SQL Server Management Studio to set up a new user for my Horizon View DB.

Let’s go through the steps to get everything set up:

  1. Login to your Microsoft SQL Server Management Studio
  2. Navigate to Security -> Logins and right-click on it
  3. Select New Login 
    newlogin-sql
  4. Under General fill the user details
    general-user-setup
  5. Under User Mapping, map your new user to your Horizon View DB
    usermapping
  6. Next, let’s open Data Sources (ODBC) and go through the setup of a new ODBC connection.
    The images below, will you walk through the process
    Screen Shot 2016-02-21 at 10.01.47 PM   Screen Shot 2016-02-21 at 10.02.08 PM
    Screen Shot 2016-02-21 at 10.02.33 PM   Screen Shot 2016-02-21 at 10.02.42 PM

 

  • The rest of the options can be left alone. Last, test your new data source:
    Screen Shot 2016-02-21 at 10.02.59 PM   Screen Shot 2016-02-21 at 10.03.05 PM

 

That’s all. Just use the name of your ODBC data source during the Horizon View Composer set up and you should be all set.

 

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *