After you create a vCenter Server user, establish a connection with a SQL Server database. This connection is required to install a vCenter Server system.

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.

Caution

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

Create a database using SQL Server Management Studio on the SQL Server. See Create a SQL Server Database and User for vCenter Server

Set database permissions using one of the following options:

Option 1 (recommended): Follow the procedures in Set Database Permissions By Manually Creating Database Roles and the VMW Schema and Use a Script to Create a Microsoft SQL Server Database Schema and Roles

Option 2 (alternative): Follow the procedures in Set Database Permissions by Using the dbo Schema and the db_owner Database Role and Use a Script to Create a vCenter Server User by Using the dbo Schema and db_owner Database Role.

1

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

2

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

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.

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.

Integrate Windows authentication. Optionally, enter the Service Principal Name (SPN).

SQL Server authentication. Type your SQL Server login name and password.

7

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

8

Click Finish.

9

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.

10

Verify that the SQL Agent is running on your database server.