If you use a Microsoft SQL database for your vCenter Server repository, you need to 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. You also can create the database manually.

2

The vCenter Server installer creates the schema during installation. For experienced database administrators who need more control over schema creation because of environmental constraints, you can optionally use a script to create your 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.