6.5.1

Table Of Contents
grant execute on l_purge_stat2_proc to vpxuser
grant execute on l_purge_stat3_proc to vpxuser
grant execute on l_stats_rollup1_proc to vpxuser
grant execute on l_stats_rollup2_proc to vpxuser
If you ran the script process_performance_data_mssql.sql in Step 5, grant the following execute
privilege to the vCenter Server database.
grant execute on process_performance_data_proc to vpxuser
You created the vCenter Server tables manually.
Note During the vCenter Server installation, when a database reinitialization warning message appears,
select Do not overwrite, leave my existing database in place and continue the installation.
Configure a SQL Server ODBC Connection
After you create and configure a SQL Server database and user for vCenter Server, you must create a
64-bit DSN on the machine on which you plan to install vCenter Server. During the vCenter Server
installation, you use the DSN to establish a connection between vCenter Server and the database.
If you use SQL Server for vCenter Server, do not use the master or any other system database.
See your Microsoft SQL ODBC documentation for specific instructions for configuring the SQL Server
ODBC connection.
Caution If you are using a named instance of Microsoft SQL Server 2008 Standard Edition with
vCenter Server, do not name the instance MSSQLSERVER. If you do, the JDBC connection does not
work, and certain features, such as Performance Charts, are not available.
Prerequisites
Deploy SQL Native Client version 10 or 11.
Procedure
1 On the machine on which you plan to install vCenter Server, select Start > Administrative Tools >
Data Sources (ODBC).
2 On the System DSN tab, modify an existing or create a new SQL Server ODBC connection.
n
To modify an existing SQL Server ODBC connection, select the connection from the System Data
Source list and click Configure.
Important The existing DSN must use SQL Native Client version 10 or 11.
n
To create a new SQL Server ODBC connection, click Add, select SQL Native Client, and click
Finish .
3 In the Name text box, enter an ODBC data source name (DSN).
For example, VMware vCenter Server.
vSphere Installation and Setup
VMware, Inc. 295