VMware Horizon View 7.0.2 Part 3 – Create ODBC Connection for View Composer Server Installation


In previous post, I had shown you the installation of Microsoft SQL 2012 with Service Pack 2. In this post, I will show you how to create ODBC connection for View Composer Server installation. First download the Microsoft SQL Server 2008 R2 Native client and copy it in to View Composer Machine. Select the Setup and right click, then select open to install the SQL Server 2008 R2 Native Client.1

To continue, click Next2

Select I accept the terms in the license agreement and click Next3

keep it default and click Next4

Select the program feature and click Next5

Click Install to begin installation6

Installing SQL Server 2008 R2 Native Client is in progress7

Click Finish to exit install wizard77

Lauch Microsoft SQL Server 2012 Managment Studio8

Click Connect to connect the Database Engine9

Select Database and right click select New Database 10

Enter Database name as ViewDB and click Ok11

Select Login and right click select New Login12

Enter Login name and select SQL Server authentication, then enter Password, Confirm password and below change the Default Database as ViewDB13

Select Server Roles, check public and sysadmin server roles14

Select User Mapping, check ViewDB to map and Database role as db_owner and public. then click Ok15

Verify the Database ViewDB and Login ViewUser details16

Login to View Composer Server Machine and click Start button7

In Start, click down arrow button and verify the installed applications8

Select ODBC Data Sources (64-bit)9

Select System DSN and click Add10

Select SQL Server Native Client 10.0 and click Finish11

Enter Name, Description and SQL Server details to connect, then click Next12

Select With SQL Server authentication using a login ID and password, then click Next13

Check Change the default database to ViewDB and click Next14

Keep it default and click Finish15

Click Test Data Source to check connectivity test16


18                            Verify the System Data Sources and driver details. Once completed the ODBC connection to View Composer Server, we have to start installing the View Composer Server step by step. Please find the below link for installation of View Composer Server step by step process. I hope this is informative for you. Thanks for reading my post……! If you feel worth please share it in social media.

VMware Horizon View 7.0.2 Part 4 – Installation of View Composer Server step by step process


About Author

Leave A Reply