7.3

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 5‑10. 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.
9 Paste the entire modified contents of CreateDatabase.sql into the query pane.
10 Below the CreateDatabase.sql content, paste the entire modified contents of
SetDatabaseSettings.sql.
11 Click Execute.
The script runs and creates the database.
What to do next
Install the IaaS Components in a Distributed Configuration.
Create the IaaS Database Using the Installation Wizard
vRealize Automation uses a Microsoft SQL Server database to maintain information about the machines
it manages and its own elements and policies.
The following steps describe how to create the IaaS database using the installer or populate an existing
empty database. It is also possible to create the database manually. See Create the IaaS Database
Manually.
Installing vRealize Automation
VMware, Inc. 76