6.7

go
GRANT EXECUTE ON msdb.dbo.sp_add_jobschedule TO VC_ADMIN_ROLE
go
GRANT EXECUTE ON msdb.dbo.sp_add_category TO VC_ADMIN_ROLE
go
sp_addrolemember VC_ADMIN_ROLE , vpxuser
go
Note The VC_ADMIN_ROLE role in the msdb database is required only during installation and
upgrade of vCenter Server. After the installation or upgrade, you can revoke the role and leave it as
inactive for future upgrades, or you can remove it for increased security.
5 Enable database monitoring for the vCenter Server database user.
For example, to grant database disk size monitoring permissions to the vpxuser user, you can run the
following script:
use master
go
grant VIEW SERVER STATE to vpxuser
go
GRANT VIEW ANY DEFINITION TO vpxuser
go
(Optional) Use a Script to Create Microsoft SQL Server Database Objects Manually
This topic describes how to create database objects manually instead of letting the vCenter Server
installer create the data objects automatically.
Procedure
1 Log in to a Microsoft SQL Server Management Studio session with the vCenter Server database user
account that you created on the vCenter Server and msdb databases.
2 In the vCenter Server installation package, locate the dbschema scripts in the vCenter-
Server/dbschema directory.
3 Open the VCDB_mssql.SQL and the TopN_DB_mssql.sql files by using Microsoft SQL Server
Management Studio and replace all occurrences of $schema with your schema name.
4 Open the VCDB_views_mssql.sql file by using Microsoft SQL Server Management Studio and after
each occurrence of ;, insert a new line and write go.
5 Run the scripts in a sequence on the database.
The DBO user must own the objects created by these scripts. Open the scripts one at a time in
Microsoft SQL Server Management Studio and press F5 to execute each script in the following order:
a
VCDB_mssql.SQL
b
insert_stats_proc_mssql.sql
c
load_stats_proc_mssql.sql
vCenter Server Installation and Setup
VMware, Inc. 96