6.7

Table Of Contents
Table 35 is not a complete list of databases supported with vCenter Server for Windows. For information
about specific database versions and service pack configurations supported with vCenter Server, see the
VMware Product Interoperability Matrixes. Only special database configuration notes not listed in the
Product Interoperability Matrixes are provided in Table 35.
vCenter Server databases require a UTF code set.
Contact your DBA for the appropriate database credentials.
Table 35. Configuration Notes for Databases Supported with vCenter Server
Database Type Configuration Notes
Embedded PostgreSQL For vCenter Server 6.7, 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 2012
SP3
Ensure that the machine has a valid ODBC DSN entry.
Microsoft SQL Server 2014
SP2
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.
vCenter Server Installation and Setup
VMware, Inc. 91