You configure network access and security between vRealize Automation and your Microsoft SQL Server database using Microsoft Distributed Transaction Coordinator (MSDTC). MSDTCcoordinates transactions that update two or more transaction-protected resources, such as databases, message queues, files systems, and so on. These transaction-protected resources may be on a single computer, or distributed across many networked computers.

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 Run,  type comexp.msc in the Open text box, and click OK.

The Component Services manager displays. Component Services lets you manage Component Object Model (COM+) applications.

3

Using the navigation tree in the left-side pane, expand Component Services > Computers > My Computer > Distributed Transaction List > Local DTC.

4

Right-click Local DTC and click Properties.

The Local DTC Properties dialog box displays.

5

Click the Security tab in the Local DTC Properties dialog box.

6

On the Security tab, configure the following values, and click OK.

Setting

Value

Network DTC Access

Selected

Allow Remote Clients

Selected

Allow Remote Administration

Deselected

Allow Inbound

Selected

Allow Outbound

Selected

Mutual Authentication Required

Selected

Enable XA Transactions

Deselected

Enable SNA LU 6.2 Transactions

Selected

Account

Leave the default setting (NT AUTHORITY\NetworkService)

Password

Leave blank


7

Click Yes to restart the MSDTC Service.

8

Click OK to confirm that the MSDTC Service has successfully restarted.

9

Close the Component Services manager.