6.5.1

Table Of Contents
vCenter Server databases require a UTF code set.
Contact your DBA for the appropriate database credentials.
Table 45. Configuration Notes for Databases Supported with vCenter Server
Database Type Configuration Notes
Embedded PostgreSQL For vCenter Server 6.5, the bundled PostgreSQL database is suitable for environments with up to
20 hosts and 200 virtual machines.
Important If you use the embedded PostgreSQL database, uninstalling vCenter Server on
Windows, uninstalls the embedded database, and all data is lost.
Microsoft SQL Server 2008
R2 SP2 or higher
Ensure that the machine has a valid ODBC DSN entry.
Microsoft SQL Server 2012 Ensure that the machine has a valid ODBC DSN entry.
Microsoft SQL Server 2014 Ensure that the machine has a valid ODBC DSN entry.
Oracle 11g and Oracle 12c Ensure that the machine has a valid ODBC DSN entry.
After you complete the vCenter Server installation, apply the latest patch to the Oracle client and
server.
Configure Microsoft SQL Server Databases
To use a Microsoft SQL database for your vCenter Server repository, configure your database to work
with vCenter Server.
You can install and configure the Microsoft SQL Server database on the same machine on which you plan
to install vCenter Server. You can install and configure the Microsoft SQL Server database on a separate
machine.
Procedure
1 Prepare the vCenter Server SQL Server Database
You first create a database and user for vCenter Server. Then you assign permissions to the
vCenter Server database user either by using the existing dbo schema and dbo_owner role or by
creating custom database schema and roles.
2 (Optional) Use a Script to Create Microsoft SQL Server Database Objects Manually
This topic describes how to create database objects manually instead of letting the vCenter Server
installer create the data objects automatically.
3 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.
4 Configure Microsoft SQL Server TCP/IP for JDBC
If the Microsoft SQL Server database has TCP/IP disabled and the dynamic ports are not set, the
JDBC connection remains closed. The closed connection causes the vCenter Server statistics to
malfunction. You can configure the server TCP/IP for JDBC.
vSphere Installation and Setup
VMware, Inc. 287