VMware VS4-ENT-PL-A - vSphere Enterprise Plus, Руководство по установке

Страница: 38 / 276

n
Grant the VC_ADMIN_ROLE to the database user in VCDB and in MSDB, and grant the
VC_USER_ROLE to the database user in VCDB. See “Set Database Permissions By Manually Creating
Database Roles and the VMW Schema,” on page 34.
Prerequisites
Create the SQL Server database. You can create the SQL Server database manually or by using a script. See
“Create a SQL Server Database and User for vCenter Server,” on page 33
Procedure
1 Log in to a Microsoft SQL Server Management Studio session as user_name for a user account that you
created on the vCenter Server and MSDB databases.
2 Locate the dbschema scripts in the vCenter Server installation
package
/installation_directory/vCenter-Server/dbschema
directory.
3 Open the
sql
file through Microsoft SQL Server Management Studio and replace all occurrences of
$schema
with the schema name in the file
VCDB_mssql.SQL
.
4 Run the scripts in 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 order shown here.
VCDB_mssql.SQL
load_stats_proc_mssql.sql
purge_stat2_proc_mssql.sql
purge_stat3_proc_mssql.sql
purge_usage_stats_proc_mssql.sql
stats_rollup1_proc_mssql.sql
stats_rollup2_proc_mssql.sql
stats_rollup3_proc_mssql.sql
cleanup_events_mssql.sql
delete_stats_proc_mssql.sql
upsert_last_event_proc_mssql.sql
load_usage_stats_proc_mssql.sql
TopN_DB_mssql.sql
calc_topn1_proc_mssql.sql
calc_topn2_proc_mssql.sql
calc_topn3_proc_mssql.sql
calc_topn4_proc_mssql.sql
clear_topn1_proc_mssql.sql
clear_topn2_proc_mssql.sql
clear_topn3_proc_mssql.sql
clear_topn4_proc_mssql.sql
rule_topn1_proc_mssql.sql
rule_topn2_proc_mssql.sql
rule_topn3_proc_mssql.sql
rule_topn4_proc_mssql.sql
process_license_snapshot_mssql.sql
l_stats_rollup3_proc_mssql.sql
l_purge_stat2_proc_mssql.sql
l_purge_stat3_proc_mssql.sql
l_stats_rollup1_proc_mssql.sql
l_stats_rollup2_proc_mssql.sql
VCDB_view_mssql.sql
vSphere Installation and Setup
38 VMware, Inc.