If you use a Microsoft SQL database for your vCenter Server repository, you must configure your database to work with vCenter Server.

1

To simplify the process of creating the SQL Server database, users, and privileges, you can run a script. If you do not use this script, you can create the database manually.

2

The vCenter Server installer creates the schema automatically during installation. Experienced database administrators who need more control over schema creation due to environmental constraints can optionally use a script to create a database schema.

3

When you install the vCenter Server system, you can establish a connection with a SQL Server database.

4

If the Microsoft SQL Server database has TCP/IP disabled and the dynamic ports are not set, the JDBC connection remains closed. This causes the vCenter Server statistics to malfunction. You can configure the server TCP/IP for JDBC.