7.1

4 Edit CreateDatabase.sql and replace all instances of the variables in the table with the correct values for
your environment.
Table 4‑15. 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 nal
slash.
$(LogDir) Path to the log directory for the database, excluding the nal
slash.
5 Review the seings in the DB Settings section of CreateDatabase.sql and edit them if needed.
The seings in the script are the recommended seings 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 modied contents of CreateDatabase.sql into the query pane.
10 Click Execute.
The script runs and creates the database.
What to do next
“Install the IaaS Components in a Distributed Conguration,” on page 74.
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,”
on page 77.
Prerequisites
n
If you are creating the database with Windows authentication, instead of SQL authentication, verify that
the user who runs the installer has sysadmin rights on the SQL server.
n
“Download the vRealize Automation IaaS Installer,” on page 76.
Procedure
1 Right-click the [e-mail] setup le and select Run as
administrator.
2 Click Next.
3 Accept the license agreement and click Next.
Chapter 4 The Standard vRealize Automation Installation Interfaces
VMware, Inc. 79