VMware VS4-ENT-PL-A Setup Guide - Page 38

vSphere Installation and Setup 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 38 VMware, Inc.