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 
  4. Under General fill the user details
  5. Under User Mapping, map your new user to your Horizon View DB
  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 *

This site uses Akismet to reduce spam. Learn how your comment data is processed.