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. |