A Windows server that hosts the IaaS SQL database must meet certain requirements.

Your SQL Server can reside on one of your IaaS Windows servers, or on a separate host. When hosted together with IaaS components, these requirements are in addition to those for all IaaS Windows servers.

  • This release of vRealize Automation does not support the default 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 the vRealize Automation installer, compatibility is already configured.

  • AlwaysOn Availability Group (AAG) is only supported with SQL Server 2016 Enterprise. When you use AAG, you specify the AAG listener FQDN as the SQL Server host.

  • When hosted together with IaaS components, configure Java.

    • Install 64-bit Java 1.8 update 161 or later. Do not use 32-bit.

      The JRE is enough. You do not need the full JDK.

    • Set the JAVA_HOME environment variable to the Java installation folder.

    • Verify that %JAVA_HOME%\bin\java.exe is available.

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

  • Enable TCP/IP protocol for SQL Server.

  • SQL Server includes a model database that is the template for all databases created on the SQL instance. For IaaS to install correctly, do not change the model database size.

  • Usually, the server needs more hardware than the minimums described in IaaS Windows Servers.

    For more information, see vRealize Automation Hardware Specifications and Capacity Maximums.

  • Before running the vRealize Automation installer, you need to identify accounts and add permissions in SQL. See Accounts and Passwords.