7.0

Table Of Contents
For a list of supported database versions, see “Database Requirements for View Composer and the Events
Database,” on page 11.
To add a View Composer database to an installed database instance, choose one of these procedures.
n
Create a SQL Server Database for View Composer on page 40
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 43
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 40
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 41
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 42
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 and the Events Database,” 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.
View Installation
40 VMware, Inc.