5.5.1

Configuring the Orchestrator Database Connection
The Orchestrator server requires a database for storing data.
The type of Orchestrator installation determines the kind of database it works with.
n
When you install Orchestrator standalone, the Orchestrator server is preconfigured to work with an
embedded database.
n
When you install Orchestrator together with vCenter Server, the Orchestrator server is preconfigured to
work with the vCenter Server datasource.
n
When you download and deploy the Orchestrator Appliance, the Orchestrator server is preconfigured
to work with the PostgreSQL database embedded in the appliance.
The embedded and PostgreSQL databases are suitable only for small-scale, medium-scale, and testing
environments. If you decide to use an embedded database, you cannot set up Orchestrator to work in cluster
mode, or change any licenses and the server certificate by using the Orchestrator configuration interface. To
change the license key and the server certificate without changing the database, you must run the
configuration workflows by using either the Orchestrator client or the REST API. For more information
about running the configuration workflows by using the Orchestrator client, see Using the VMware vCenter
Orchestrator Plug-Ins. For detailed instructions about running the configuration workflows by using the
REST API, see Chapter 8, “Configuring Orchestrator by Using the Configuration Plug-In and the REST
API,” on page 73.
For better performance in a production environment, install a relational database management system
(RDBMS) and create a new database for Orchestrator. For more information about creating a new database
for Orchestrator, see “Orchestrator Database Setup,” on page 20. If you decide to use a separate database,
configure the database for remote connection. For an example of configuring SQL Server Express for remote
connection, see “Configure SQL Server Express to Use with Orchestrator,” on page 52.
Configure SQL Server Express to Use with Orchestrator
You can use Microsoft SQL Server Express in small-scale environments.
Orchestrator can work with SQL Server Express when the deployment does not exceed 5 hosts and 50
virtual machines.
To use SQL Server Express with Orchestrator, you must configure the database to enable TCP/IP.
Procedure
1 Log in as an administrator to the machine on which SQL Server Express is installed.
2 Click Start > All Programs > Microsoft SQL Server 2008 R2 > Configuration Tools > SQL Server
Configuration Manager.
3 Expand in the list on the left.
4 Click Protocols for SQLEXPRESS.
5 Right-click TCP/IP and select Enable.
6 Right-click TCP/IP and select Properties.
7 Click the IP Addresses tab.
8 Under IP1, IP2, and IPAll, set the TCP Port value to 1433.
9 Click OK.
10 Click on the left.
11 Restart the SQL Server.
Installing and Configuring VMware vCenter Orchestrator
52 VMware, Inc.