The Windows server that hosts the vRealize Automation IaaS SQL Server database must meet certain prerequisites.

The requirements apply whether you run the Installation Wizard or the legacy setup_vrealize-automation-appliance-URL.exe installer and select the database role for installation. The prerequisites also apply if you separately create an empty SQL Server database for use with IaaS.

  • Use a supported SQL Server version from the vRealize Automation Support Matrix.

  • Enable TCP/IP protocol for SQL Server.

  • Enable the Distributed Transaction Coordinator (DTC) service on all IaaS Windows servers and the machine that hosts SQL Server. IaaS uses DTC for database transactions and actions such as workflow creation.

    Note:

    If you clone a machine to make an IaaS Windows server, install DTC on the clone after cloning. If you clone a machine that already has DTC, its unique identifier is copied to the clone, which causes communication to fail. See Error in Manager Service Communication.

    For more about DTC enablement, see VMware Knowledge Base article 2038943.

  • Open ports between all IaaS Windows servers and the machine that hosts SQL Server. See vRealize Automation Port Requirements.

    Alternatively, if site policies allow, you may disable firewalls between IaaS Windows servers and SQL Server.

  • This release of vRealize Automation does not support SQL Server 2016 130 compatibility mode. If you separately create an empty SQL Server 2016 database for use with IaaS, use 100 or 120 compatibility mode.

    If you create the database through a vRealize Automation installer, compatibility is already configured.

  • AlwaysOn Availability Group (AAG) is only supported with SQL Server 2016.