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

Procedure

  1. Log in to the SQL Server virtual machine by using a Remote Desktop Protocol (RDP) client.
    1. Open an RDP connection to the vra01mssql01.rainpole.local virtual machine.
    2. Log in using the following credentials.

      Settings

      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 Coordinator > 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. In 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, click OK to confirm that the service has successfully restarted, and close the Component Services manager.