Installation

6 In the View Composer database, grant the schema permissions SELECT, INSERT, DELETE, UPDATE,
and EXECUTE on the dbo schema to the VCMP_USER_ROLE.
7 Grant the VCMP_USER_ROLE to the user [vcmpuser].
8 Grant the VCMP_ADMIN_ROLE to the user [vcmpuser].
9 In the MSDB database, create the database role VCMP_ADMIN_ROLE.
10 Grant privileges to the VCMP_ADMIN_ROLE in MSDB.
a On the MSDB tables syscategories, sysjobsteps, and sysjobs grant the SELECT permission to the
user [vcmpuser].
b On the MSDB stored procedures sp_add_job, sp_delete_job, sp_add_jobstep, sp_update_job,
sp_add_jobserver, sp_add_jobschedule, and sp_add_category, grant the EXECUTE permission to
the role VCMP_ADMIN_ROLE.
11 In the MSDB database, grant the VCMP_ADMIN_ROLE to the user [vcmpuser].
12 Create the ODBC DSN using the SQL Server login vcmpuser.
13 Install View Composer.
14 In the MSDB database, revoke the VCMP_ADMIN_ROLE from the user [vcmpuser].
After you revoke the role, you can leave the role as inactive or remove the role for increased security.
For instructions for creating an ODBC DSN, see “Add an ODBC Data Source to SQL Server,” on page 36.
For instructions for installing View Composer, see “Install the View Composer Service,” on page 41.
Add an ODBC Data Source to SQL Server
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.
When you configure an ODBC DSN for View Composer, secure the underlying database connection to an
appropriate level for your environment. For information about securing database connections, see the SQL
Server documentation.
If the underlying database connection uses SSL encryption, we recommend that you configure your
database servers with SSL certificates signed by a trusted CA. If you use self-signed certificates, your
database connections might be susceptible to man-in-the-middle attacks.
Prerequisites
Complete the steps described in “Add a View Composer Database to SQL Server,” on page 34.
Procedure
1 On the computer on which View Composer will be installed, select Start > Administrative Tools > Data
Source (ODBC).
2 Select the System DSN tab.
3 Click Add and select SQL Native Client from the list.
4 Click Finish.
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
View Installation
36 VMware, Inc.