One of the prerequisites for installing vRealize Automation in Cloud Foundation is configuring Microsoft SQL Server. Specifically, you must join the SQL Server VM to Active Directory, create a new administrative user for SQL Server access, and create the SQL database.

Prerequisites

  • Microsoft SQL Server

    For a complete list of supported versions, see the vRealize Automation Support Matrix (PDF).

  • Active Directory

  • Verify that you have the administrative permissions necessary to make configuration changes to both Active Directory and Microsoft SQL Server.

Procedure

  1. For Microsoft SQL Server, configure a firewall exception on port 1433.
  2. Join the Microsoft SQL Server VM to Active Directory.
    1. In the Computer Name/Domain Changes screen, select the domain and enter the domain name.
    2. Click OK.
    3. Specify the credentials and reboot the VM to apply the new settings.
  3. Enable Microsoft Distributed Transaction Coordinator (MSDTC) on the Microsoft SQL Server VM.
    1. Open the Component Services manager and click Run.
    2. Enter comexp.msc in the Open field, and click OK.
    3. In the navigation tree, select Component Services > Computers > My Computer > Distributed Transaction List > Local DTC.
    4. Right-click Local DTC and choose Properties to open the Local DTC Properties dialog box.
    5. Click the Security tab and select the following options:
      • Network DTC Access

      • Allow Remote Clients

      • Allow Inbound

      • Allow Outbound

    6. Click OK.
  4. Create the vRealize Automation database login.
    1. Open SQL Server Management Studio and connect to the SQL server instance.
    2. Navigate to the Security > Logins page, and select New Login.
    3. Select the General tab and enter the service user name (for example, rainpole\svc-vra) in the Login Name field.
    4. Select the Server Roles tab and select the sysadmin option, and click OK.
  5. Create an empty database for vRealize Automation.
    1. Open SQL Server Management Studio and connect to the SQL server instance.
    2. In the Object Explorer, right-click Databases and choose New Database.
    3. The New Database dialog box, select the General tab and enter the database name, for example, vRA.
    4. Set database owner to the same value as the service user name, for example svc-vra
    5. Select the Options tab and configure the following settings:
      • Set Recovery Model option to Simple.

      • Under Other options, select the Snapshot Isolation option.

      • Under Other options, select the Read Committed Snapshot option.

    6. Click OK.