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


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.


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.


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


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.