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.

Before 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
      
      

 

• The rest of the options can be left alone. Last, test your new data source:
     

 

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.