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

Before you begin

  • Set up a new database to use with the Orchestrator server. See Setting Up the Orchestrator Database.

  • If you are using an SQL Server database configured to use dynamic ports, verify that the SQL Server Browser service is running.

  • To prevent possible transactional deadlocks when the database is Microsoft SQL Server database, set the ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT database options on.

  • To avoid an ORA-01450 error when using the Oracle database, verify that you have configured the database block size properly. The minimum allowed size depends on the block size your Oracle database index is using.

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

  • To configure Orchestrator to communicate with the database over a secure connection, make sure that you import the database SSL certificate. For more information, see Import the Database SSL Certificate.

Procedure

  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.

    Option

    Description

    Oracle

    Configures Orchestrator to work with an Oracle database instance.

    SQL Server

    Configures Orchestrator to work with a Microsoft SQL Server or Microsoft SQL Server Express database instance.

    PostgreSQL

    Configures Orchestrator to work with a PostgreSQL database instance.

    vDB

    Configures Orchestrator to work with the vCenter Server database.

    Embedded Database

    Configures Orchestrator to work with the embedded database.

  4. Define the database connection parameters and click Apply changes.

    Option

    Description

    User name

    The user name that Orchestrator uses to connect and operate the selected database. The name you select must be a valid user on the target database with db_owner rights.

    This option is applicable for all databases.

    Password (if any)

    The password for the user name.

    This option is applicable for all databases.

    Use SSL

    Select to use an SSL connection to the database. To use this option, you must make sure that you import the database SSL certificate into Orchestrator.

    This option is applicable for all databases.

    Database server IP address or DNS name

    The database server IP address or DNS name.

    This option is applicable for all databases.

    Port

    The database server port is used for communication to your database.

    This option is applicable for all databases.

    Database name

    The full unique name of your database. The database name is specified in the SERVICE_NAMES parameter in the initialization parameter file.

    This option is valid only for SQL Server, and PostgreSQL databases.

    Instance name (if any)

    The name of the database instance that can be identified by the INSTANCE_NAME parameter in the database initialization parameter file.

    This option is valid only for SQL Server and Oracle databases.

    Domain

    To use Windows authentication, type the domain name of the SQL Server machine, for example company.org.

    To use SQL authentication, leave this text box blank.

    This option is valid only for SQL Server and specifies whether you want to use Windows or SQL Server authentication.

    Use Windows authentication mode (NTLMv2)

    Select to send NTLMv2 responses when using Windows authentication.

    This option is valid only for SQL Server.

    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 build or update the database table structure.

  5. (Optional) : Build or update the table structure for Orchestrator.

    Option

    Description

    Create the database tables

    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.

Results

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

Configure Orchestrator to Work with SQL Server Express by Using Windows Authentication Mode

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

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

  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.