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.

1

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

This topic describes how to create database objects manually instead of letting the vCenter Server installer create the data objects automatically.

3

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

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.