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.

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.

The default database for the DBO user is the one that you created using SQL Server Management Studio.

Make sure that the database login has the db_owner fixed database role on the vCenter Server database and on the MSDB database. The db_owner role on the MSDB database is required for installation and upgrade only. You can revoke this role after installation.

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.

1

On your vCenter Server system, open the Microsoft Windows ODBC Data Source Administrator.

On a 32-bit system, select Settings > Control Panel > Administrative Tools > Data Sources (ODBC).

On a 64-bit system, open C:\WINDOWS\SYSWOW64\odbc32.exe.

2

On the System DSN tab modify or create a SQL Server ODBC connection.

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.

3

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

For example, VMware vCenter Server.

4

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

5

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.

6

Select one of the authentication methods.

7

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

8

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

9

Click Finish.

To test the data source, from the ODBC Microsoft SQL Server Setup menu, select Test Data Source and click OK. Ensure that the SQL Agent is running on your database server.

This applies to SQL Server 2005 and SQL Server 2008 editions.