7.4

Table Of Contents
What to do next
Install the IaaS Components in a Distributed Configuration.
Prepare an Empty Database
A vRealize Automation system administrator can install the IaaS schema on an empty database. This
installation method provides maximum control over database security.
Prerequisites
n
Verify the database installation prerequisites. See IaaS SQL Server Host.
n
Open a Web browser to the vRealize Automation appliance installer URL, and download the IaaS
database installation scripts.
https://vrealize-automation-appliance-FQDN:5480/installer
Procedure
1 Navigate to the Database directory within 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 sysadmin privileges within the SQL Server instance.
4 Edit the following files, and replace all instances of the variables in the table with the correct values
for your environment.
CreateDatabase.sql
SetDatabaseSettings.sql
Table 510. Database Values
Variable Value
$(DBName) Name of the database, such as vra. Database names must consist
of no more than 128 ASCII characters.
$(DBDir) Path to the data directory for the database, excluding the final
slash.
$(LogDir) Path to the log directory for the database, excluding the final slash.
5 Review the settings in the DB Settings section of SetDatabaseSettings.sql and edit them if
needed.
The settings in the script are the recommended settings for the IaaS database. Only
ALLOW_SNAPSHOT_ISOLATION ON and READ_COMMITTED_SNAPSHOT ON are required.
6 Open SQL Server Management Studio.
7 Click New Query.
An SQL Query window opens.
8 On the Query menu, ensure that SQLCMD Mode is selected.
Installing vRealize Automation
VMware, Inc. 77