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 SQL Server Network Configuration 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 Server Services on the left.

11

Restart the SQL Server.

You can now use SQL Server 2008 Express R2 to create and manage Orchestrator databases.

What to do next

Configure the Orchestrator database connection parameters.