Your environment must meet these general requirements that support the installation of the IaaS Database (SQL Server).

  • TCP/IP protocol enabled for MS SQL Server

  • Microsoft Distributed Transaction Coordinator Service (MS DTC) enabled on all SQL nodes in the system. MS DTC is required to support database transactions and actions such as workflow creation.

  • No firewalls between Database Server and the Web server or IaaS Server, or ports opened as described in Port Requirements.

  • For 6.0.x installations, the database name cannot contain a space. For 6.1 and later installations, the use of spaces in names is supported.

Note:

If you clone an IaaS node, install MS DTC on each node after it has been cloned. When you clone a node that has MS DTC installed, its unique identifier is copied to each clone, which causes communication to fail. See Error in Manager Service Communication for further information.

For information about supported MS SQL versions, see vRealize Automation Support Matrix for this release.