Installation

Table Of Contents
n
Create a SQL Server Database for View Composer on page 34
View Composer can store linked-clone desktop information in a SQL Server database. You create a
View Composer database by adding it to SQL Server and configuring an ODBC data source for it.
n
Create an Oracle Database for View Composer on page 37
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.
Create a SQL Server Database for View Composer
View Composer can store linked-clone desktop information in a SQL Server database. You create a View
Composer database by adding it to SQL Server and configuring an ODBC data source for it.
Procedure
1 Add a View Composer Database to SQL Server on page 34
You can add a new View Composer database to an existing Microsoft SQL Server instance to store
linked-clone data for View Composer.
2 (Optional) Set SQL Server Database Permissions By Manually Creating Database Roles on page 35
By using this recommended method, the View Composer database administrator can set permissions
for View Composer administrators to be granted through Microsoft SQL Server database roles.
3 Add an ODBC Data Source to SQL Server on page 36
After you add a View Composer database to SQL Server, you must configure an ODBC connection to
the new database to make this data source visible to the View Composer service.
Add a View Composer Database to SQL Server
You can add a new View Composer database to an existing Microsoft SQL Server instance to store linked-
clone data for View Composer.
If the database resides locally, on the system on which View Composer will be installed, you can use the
Integrated Windows Authentication security model. If the database resides on a remote system, you cannot
use this method of authentication.
Prerequisites
n
Verify that a supported version of SQL Server is installed on the computer on which you will install
View Composer or in your network environment. For details, see “Database Requirements for View
Composer,” on page 11.
n
Verify that you use SQL Server Management Studio to create and administer the database.
Alternatively, you can use SQL Server Management Studio Express, which you can download and
install from the following Web site.
http://www.microsoft.com/en-us/download/details.aspx?id=7593
Procedure
1 On the View Composer computer, select Start > All Programs > Microsoft SQL Server 2014, Microsoft
SQL Server 2012 or Microsoft SQL Server 2008.
2 Select SQL Server Management Studio and connect to the SQL Server instance.
3 In the Object Explorer panel, right-click the Databases entry and select New Database.
You can use the default values for the Initial size and Autogrowth parameters for the database and
log files.
View Installation
34 VMware, Inc.