vRealize Automation IaaS uses a Microsoft SQL Server database to maintain information about the machines it manages and its own elements and policies.

Depending on your preferences and privileges, there are several procedures to choose from to create the IaaS database.

Note:

You can enable secure SSL when creating or upgrading the SQL database. For example, when you create or upgrade the SQL database, you can use the Secure SSL option to specify that the SSL configuration which is already specified in the SQL server be enforced when connecting to the SQL database. SSL provides a more secure connection between the IaaS server and SQL database. This option, which is available in the custom installation wizard, requires that you have already configured SSL on the SQL server. For related information about configuring SSL on the SQL server, see KB 316898 How to enable SSL encryption for an instance of SQL Server by using Microsoft Management Console at the Microsoft support site.

Table 1. Choosing an IaaS Database Scenario

Scenario

Procedure

Create the IaaS database manually using the provided database scripts. This option enables a database administrator to review the changes carefully before creating the database.

Create the IaaS Database Manually.

Prepare an empty database and use the installer to populate the database schema. This option enables the installer to use a database user with dbo privileges to populate the database, instead of requiring sysadmin privileges.

Prepare an Empty Database.

Use the installer to create the database. This is the simplest option but requires the use of sysadmin privileges in the installer.

Create the IaaS Database Using the Installation Wizard.