The vCenter Server installer creates the schema during installation. For experienced database administrators who need more control over schema creation because of environmental constraints, you can optionally use a script to create your database schema.

To have the vCenter Server installer create your schema for you, see Configure a SQL Server ODBC Connection.

Create the SQL Server database. You can create the SQL Server database manually or by using a script.

1

Create a vCenter Server database user with the db_datawriter and db_datareader permissions.

2

Open a query analyzer window with a user having DBO rights on the vCenter Server and MSDB databases.

3

Locate the dbschema scripts in the vCenter Server installation package /<installation directory>/vpx/dbschema directory.

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 the Query Analyzer window and press F5 to execute each script in the order shown here.

VCDB_mssql.SQL
load_stats_proc_mssql.sql
purge_stat1_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
5

For all supported editions of Microsoft SQL Server (except Microsoft SQL Server 2005 Express), run these scripts to set up scheduled jobs on the database. These scripts ensure that the SQL Server Agent service is running.

job_schedule1_mssql.sql
job_schedule2_mssql.sql
job_schedule3_mssql.sql
job_cleanup_events_mssql.sql
job_topn_past_day_mssql.sql
job_topn_past_week_mssql.sql
job_topn_past_month_mssql.sql
job_topn_past_year_mssql.sql
1

On the machine on which you intend to install vCenter Server, create a DSN that points to the database server with the schema.

2

Run the vCenter Server installer.

a

If a database reinitialization warning message appears in the vCenter Server installer, select Do not overwrite, leave my existing database in place and continue the installation.

This message appears if you are using a database that has vCenter Server tables created by a previous installation. The message does not appear if the database is clean.

If you leave your existing database in place, you cannot join a Linked Mode group during the installation. You can join after the installation is complete. (See Join a Linked Mode Group After Installation.)

b

When prompted, provide the database user login.