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, the requirements are in addition to those for all IaaS Windows servers.

  • When hosted together with IaaS components, configure Java.

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

    • 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.

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

  • 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.