To establish a connection to the Orchestrator database, you must configure the database connection parameters.

Set up a new database to use with the Orchestrator server. See Orchestrator Database Setup.

For a list of database connection parameters, see Database Connection Parameters.

If you are using an SQL Server database, verify that the SQL Server Browser service is running.

To store characters in the correct format in an Oracle database, set the NLS_CHARACTER_SET parameter to AL32UTF8 before configuring the database connection and building the table structure for Orchestrator. This setting is crucial for an internationalized environment.

1

Log in to the Orchestrator configuration interface as vmware.

2

Click Database.

3

From the Select the database type drop-down menu, select the type of database that you want Orchestrator server to use.

Note

Orchestrator supports Oracle, SQL Server, and SQL Server Express.

4

Specify the database connection parameters.

If the specified parameters are correct, a message states that the connection to the database is successful.

Note

Although Orchestrator has established a connection to the database, the database configuration is not yet complete. You must install or update the database.

5

To build or update the table structure for Orchestrator, install or update the database.

Option

Description

Install the database

Builds a new table structure for the Orchestrator database.

Update the database

Uses the database from your previous Orchestrator installation and updates the table structure.

After the database is populated, you can reset the database access rights to db_dataread and db_datawrite.

6

Click Apply changes.

Note

If you change the Orchestrator database after configuring and installing the default plug-ins, you must click the Troubleshooting tab and force plug-in reinstallation by clicking the Reset current version link. This operation deletes the install_directory\app-server\server\vmo\plugins\_VSOPluginInstallationVersion.xml file, which holds the version of the plug-ins already installed, and forces plug-in reinstallation.

The database configuration is successfully updated. On the Database tab, the red triangle changes to a green circle to indicate that the component is now configured correctly.

If you want to use Orchestrator in small scale deployments for testing purposes, you might want to use SQL Server Express 2008 which you can install together with vCenter Server. After you create a new database for example vco, and enable it for remote connection, to configure the database connection perform the following steps:

1

Log in to the Orchestrator configuration interface as vmware.

2

Click the Database tab.

3

From the Select the database type drop-down menu, select SQLServer.

4

In the User name and Password (if any) text boxes, type your Windows credentials.

5

In the Database host IP address or DNS name text box, type the IP address of the machine on which Orchestrator and the database are installed.

6

In the Port text box, type the TCP/IP port of SQL Server, which usually is 1433.

7

In the Database name text box, type the name of the SQL Server Express database you created, for example vco.

8

In the Instance name (if any) text box, type the name of the database instance.

You can leave this field blank, if you have only one instance of SQL Server installed on the machine.

9

In the Domain text box either type the domain name of the machine on which Orchestrator and the database are installed, or type localhost.

10

Select Use Windows authentication mode (NTLMv2).

11

Click Apply.

12

Build or update the database as necessary and click Apply changes.

You successfully configured Orchestrator to work with SQL Server Express by using Windows authentication mode.