7.2

Table Of Contents
Choosing an IaaS Database Scenario
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.
N 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 conguration
which is already specied 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 congured SSL on the SQL server. For related
information about conguring SSL on the SQL server, see Microsoft Knowledge Base article 316898.
Table 410. 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,” on page 77.
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,” on page 78.
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,”
on page 79.
Create the IaaS Database Manually
The vRealize Automation system administrator can create the database manually using VMware-provided
scripts.
Prerequisites
n
Microsoft .NET Framework 4.5.2 or later must be installed on the SQL Server host.
n
Use Windows Authentication, rather than SQL Authentication, to connect to the database.
n
Verify the database installation prerequisites. See “IaaS Database Server Requirements,” on page 21.
n
Open a Web browser to the vRealize Automation appliance installer URL, and download the IaaS
database installation scripts.
hps://vrealize-automation-appliance-FQDN:5480/installer
Procedure
1 Navigate to the Database subdirectory in the directory where you extracted the installation zip archive.
2 Extract the DBInstall.zip archive to a local directory.
3 Log in to the Windows database host with sucient rights to create and drop databases sysadmin
privileges in the SQL Server instance.
Chapter 4 The Standard vRealize Automation Installation Interfaces
VMware, Inc. 77