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

If you use SQL Server for vCenter Server, do not use the master database.

See your Microsoft SQL ODBC documentation for specific instructions regarding configuring the SQL Server ODBC connection.

If you are using a named instance of Microsoft SQL Server 2008 Standard Edition with vCenter Server, do not name the instance MSSQLSERVER. If you do, the JDBC connection does not work, and certain features, such as Performance Charts, are not available.

Review the required database patches specified in vCenter Server Database Patch and Configuration Requirements. If you do not prepare your database correctly, the vCenter Server installer displays error and warning messages.

Create a database using SQL Server Management Studio on the SQL Server.

Create a database user with database operator (DBO) rights.


On your vCenter Server system, select Settings > Control Panel > Administrative Tools > Data Sources (ODBC).


Select the System DSN tab and do one of the following.

To modify an existing SQL Server ODBC connection, select the connection from the System Data Source list and click Configure.

To create a new SQL Server ODBC connection, click Add, select SQL Native Client, and click Finish.


Type an ODBC datastore name (DSN) in the Name text box.

For example, VMware vCenter Server.


(Optional) Type an ODBC DSN description in the Description text box.


Select the server name from the Server drop-down menu and click Next.

Type the SQL Server host name in the text box if it is not in the drop-down menu.


Select one of the authentication methods.


If you selected SQL authentication, type your SQL Server login name and password and click Next.


Select the database created for the vCenter Server system from the Change the default database to menu and click Next.


Click Finish.

For SQL Server 2005 and SQL Server 2008 editions, test the data source by selecting Test Data Source and clicking OK from the ODBC Microsoft SQL Server Setup menu. Ensure that the SQL Agent is running on your database server.