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


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.


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.