4.2

Example: 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 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.
Database Connection Parameters
To establish a connection to the database, you must specify the database connection parameters. Depending
on the type of database you are connecting to, the required information might vary.
Table 5-5. Database Connection Parameters
Connection Parameter 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.
Password The password for the user name you entered.
Database host IP address or
DNS name
The database server IP address or DNS name.
Port The database server port that allows communication to your database.
Database name The full unique name of your database. The database name is specified by the
SERVICE_NAMES parameter in the initialization parameter file.
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.
Installing and Configuring VMware vCenter Orchestrator
50 VMware, Inc.