6.1

4 In the New Database dialog box, type a name in the Database name text box.
For example: ViewComposer
5 Click OK.
SQL Server Management Studio adds your database to the Databases entry in the Object Explorer
panel.
6 Exit Microsoft SQL Server Management Studio.
What to do next
Optionally, follow the instructions in “(Optional) Set SQL Server Database Permissions By Manually
Creating Database Roles,” on page 35
Follow the instructions in “Add an ODBC Data Source to SQL Server,” on page 36.
(Optional) Set SQL Server Database Permissions By Manually Creating Database
Roles
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.
VMware recommends this method because it removes the requirement to set up the db_owner role for View
Composer administrators who install and upgrade View Composer.
In this procedure, you can provide your own names for the database login name, user name, and database
roles. The user [vcmpuser] and database roles, VCMP_ADMIN_ROLE and VCMP_USER_ROLE, are
example names. The dbo schema is created when you create the View Composer database. You must use
the dbo schema name.
Prerequisites
n
Verify that a View Composer database is created. See “Add a View Composer Database to SQL Server,”
on page 34.
Procedure
1 Log in to a Microsoft SQL Server Management Studio session as the sysadmin (SA) or a user account
with sysadmin privileges.
2 Create a user who will be granted the appropriate SQL Server database permissions.
use ViewComposer
go
CREATE LOGIN [vcmpuser] WITH PASSWORD=N'vcmpuser!0', DEFAULT_DATABASE=ViewComposer,
DEFAULT_LANGUAGE=us_english, CHECK_POLICY=OFF
go
CREATE USER [vcmpuser] for LOGIN [vcmpuser]
go
use MSDB
go
CREATE USER [vcmpuser] for LOGIN [vcmpuser]
go
3 In the View Composer database, create the database role VCMP_ADMIN_ROLE.
4 In the View Composer database, grant privileges to the VCMP_ADMIN_ROLE.
a Grant the schema permissions ALTER, REFERENCES, and INSERT on the dbo schema.
b Grant the permissions CREATE TABLE, CREATE VIEW, and CREATE PROCEDURES.
5 In the View Composer database, create the VCMP_USER_ROLE.
Chapter 5 Installing View Composer
VMware, Inc. 35