{"id":1142,"date":"2016-02-22T08:22:09","date_gmt":"2016-02-22T16:22:09","guid":{"rendered":"https:\/\/45.77.187.106\/?p=1142"},"modified":"2016-06-20T21:55:19","modified_gmt":"2016-06-21T04:55:19","slug":"odbc-connection-for-horizon-view-composer","status":"publish","type":"post","link":"https:\/\/mindthevirt.com\/odbc-connection-for-horizon-view-composer\/","title":{"rendered":"Setting up an ODBC connection for Horizon View Composer"},"content":{"rendered":"

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.<\/p>\n

\"odbc<\/a>Before actually setting up a new ODBC Data Source for VMware\u00a0View Composer, you’ll need to create a user and password on your database server.<\/p>\n

In my case, I used Microsoft SQL Server 2012 and used Microsoft\u00a0SQL Server Management Studio to set up a new user for my Horizon View DB.<\/p>\n

Let’s go through the steps to get everything set up:<\/p>\n

<\/p>\n

    \n
  1. Login to your Microsoft SQL Server Management Studio<\/li>\n
  2. Navigate to Security<\/strong> -> Logins<\/strong> and right-click on it<\/li>\n
  3. Select New Login\u00a0<\/strong>
    \n    \"newlogin-sql\"<\/a><\/li>\n
  4. Under\u00a0General<\/strong> fill the user details
    \n    \"general-user-setup\"<\/a><\/li>\n
  5. Under\u00a0User Mapping<\/strong>, map your new user to your Horizon View DB
    \n    \"usermapping\"<\/a><\/li>\n
  6. Next, let’s open\u00a0Data Sources (ODBC)<\/strong> and go through the setup of a new ODBC connection.
    \nThe images below, will you walk through the process
    \n    \"Screen\u00a0 \u00a0<\/a>\"Screen
    \n<\/a>    \"Screen<\/a>\u00a0 \u00a0\"Screen<\/a><\/li>\n<\/ol>\n

     <\/p>\n