7.0

Table Of Contents
5 In the Create a New Data Source to SQL Server setup wizard, type a name and description of the View
Composer database.
For example: ViewComposer
6 In the Server text box, type the SQL Server database name.
Use the form host_name\server_name, where host_name is the name of the computer and server_name is
the SQL Server instance.
For example: VCHOST1\VIM_SQLEXP
7 Click Next.
8 Make sure that the Connect to SQL Server to obtain default settings for the additional configuration
options check box is selected and select an authentication option.
Option Description
Integrate Windows authentication
Select this option if you are using a local instance of SQL Server. This
option is also known as trusted authentication. Integrate Windows
authentication is supported only if SQL Server is running on the local
computer.
SQL Server authentication
Select this option if you are using a remote instance of SQL Server.
Windows NT authentication is not supported on remote SQL Server.
If you manually set SQL Server database permissions and assigned them
to a user, authenticate with that user. For example, authenticate with the
user vcmpuser. If not, authenticate as the sysadmin (SA) or a user account
with sysadmin privileges.
9 Click Next.
10 Select the Change the default database to check box and select the name of the View Composer
database from the list.
For example: ViewComposer
11 If the SQL Server connection is configured with SSL enabled, navigate to the Microsoft SQL Server DSN
Configuration page and select Use strong encryption for data.
12 Finish and close the Microsoft ODBC Data Source Administrator wizard.
What to do next
Install the new View Composer service. See “Install the View Composer Service,” on page 47.
Create an Oracle Database for View Composer
View Composer can store linked-clone desktop information in an Oracle 12c or 11g database. You create a
View Composer database by adding it to an existing Oracle instance and configuring an ODBC data source
for it. You can add a new View Composer database by using the Oracle Database Configuration Assistant or
by running a SQL statement.
n
Add a View Composer Database to Oracle 12c or 11g on page 44
You can use the Oracle Database Configuration Assistant to add a new View Composer database to an
existing Oracle 12c or 11g instance.
n
Use a SQL Statement to Add a View Composer Database to an Oracle Instance on page 44
n
Configure an Oracle Database User for View Composer on page 45
By default, the database user that runs the View Composer database has Oracle system administrator
permissions. To restrict the security permissions for the user that runs the View Composer database,
you must configure an Oracle database user with specific permissions.
Chapter 6 Installing View Composer
VMware, Inc. 43