6.5.1

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 Oracle ODBC connection.
n
To modify an existing Oracle ODBC connection, select the connection from the System Data
Source list and click Configure.
n
To create an Oracle ODBC connection, click Add, select the Oracle client, and click Finish.
3 In the Data Source Name text box, enter an ODBC data source name (DSN).
For example, VMware vCenter Server.
4 (Optional) In the Description text box, enter an ODBC DSN description.
5 In the TNS Service Name text box, enter the net service name for the database to which you want to
connect.
For example, VPX_TNS.
This is the net service name that you previously configured in the tnsnames.ora file that is located in
the NETWORK\ADMIN folder in the Oracle database installation location.
6 In the User ID text box, enter the database user name for vCenter Server.
For example, VPXADMIN.
7 Click Test Connection.
8 In the Password text box, enter the password of the database user and click OK.
If you configured the DNS correctly, the Connection successful message appears.
9 Click OK.
Database Permission Requirements for vCenter Server
vCenter Server requires a database. If you decide to use an external Oracle or Microsoft SQL Server
database, when you create the database, you must grant certain permissions to the database user.
Table 4‑6. Microsoft SQL Database Permissions for vCenter Server
Permission Description
GRANT ALTER ON SCHEMA :: [VMW] TO VC_ADMIN_ROLE Mandatory when you work with SQL Server custom schema.
GRANT REFERENCES ON SCHEMA :: [VMW] TO
VC_ADMIN_ROLE
Mandatory when you work with SQL Server custom schema.
GRANT INSERT ON SCHEMA :: [VMW] TO
VC_ADMIN_ROLE
Mandatory when you work with SQL Server custom schema.
GRANT CREATE TABLE TO VC_ADMIN_ROLE Necessary for creating a table.
GRANT CREATE VIEW TO VC_ADMIN_ROLE Necessary for creating a view.
GRANT CREATE PROCEDURE TO VC_ADMIN_ROLE Necessary for creating a stored procedure.
vSphere Installation and Setup
VMware, Inc. 302