vRealize Orchestrator requires a database for storing data related to workflows and actions. You must create an empty database specifically for use by vRealize Orchestrator. For information on creating a new database using Microsoft SQL Server, see the documentation supplied by your database vendor.

1

Log in to the VRA01MSSQL01.rainpole.local by using a Remote Desktop Protocol (RDP) client.

a

Open an RDP connection to the virtual machine VRA01MSSQL01.rainpole.local.

b

Log in using the following credentials.

Setting

Value

User name

Windows administrator user

Password

windows_administrator_password

2

From the Start menu, click All Programs, click Microsoft SQL Server, and click SQL Server Management Studio.

Note

If SQL Server Management Studio doesn't appear in your All Programs menu, you may not have successfully installed SQL Server Management Studio. Verify that you have successfully installed SQL Server Management Studio, and then continue with this procedure.

3

In the Connect to Server dialog box, leave the Server Name text box with its default value, select Windows Authentication from the Authentication drop-down menu, and click Connect.

Note

During the SQL Server installation, the Database Engine configuration wizard prompts you to provide the SQL server administrator rainpole\svc-vra user name. If this user was not added during the SQL Server installation, select SQL Authentication from the Authentication drop-down menu, and enter the user name sa in the User name text box, and the password sa_password in the Password text box.


4

In Object Explorer, expand the server instance VRA01MSSQL01.

5

Right-click the Databases folder, and click New Database.


The New Database dialog box displays.

6

On the General page of the New Database dialog box, enter VRODB-01 in the Database name text box.


7

Select the Options page.

8

On the Options page, specify the following values, and click OK

a

Select Simple from the Recovery model drop-down menu.

b

In the Miscellaneous text box, specify True for the settings listed in the table below.

Setting

Value

Allow Snapshot Isolation

True

Is Read Committed Snapshot On

True


9

In the Object Explorer Details pane, expand the VRODB-01 database server.

10

Expand the Security folder, then expand the Users folder.

11

Right-click the User folder and click New User.


12

In the User name text box enter the vRealize Orchestrator service account name RAINPOLE\svc-vro.

Setting

Value

User type

SQL user with login

User name

Rainpole\svc-vro

Login name

Rainpole\svc-vro


13

Select the Membership page.

The Database User - New page appears.

14

In the Database role membership list item field, select the db_owner check box, and click OK.