7.1

Table Of Contents
4 Review the database deployment scripts as needed. In particular, review the seings in the DBSettings
section of CreateDatabase.sql and edit them if necessary.
The seings in the script are the recommended seings. Only ALLOW_SNAPSHOT_ISOLATION ON and
READ_COMMITTED_SNAPSHOT ON are required.
5 Execute the following command with the arguments described in the table.
BuildDB.bat /p:DBServer=db_server;
DBName=db_name;DBDir=db_dir;
LogDir=[log_dir];ServiceUser=service_user;
ReportLogin=web_user;
VersionString=version_string
Table 414. Database Values
Variable Value
db_server Species the SQL Server instance in the format
dbhostname[,port number]\SQL instance. Specify a port
number only if you are using a non-default port. The
Microsoft SQL default port number is 1433. The default value
for db_server is localhost.
db_name
Name of the database. The default value is vra. Database
names must consist of no more than 128 ASCII characters.
db_dir Path to the data directory for the database, excluding the nal
slash.
log_dir Path to the log directory for the database, excluding the nal
slash.
service_user User name under which the Manager Service runs.
Web_user User name under which the Web services run.
version_string The vRealize Automation version, found by logging in to the
vRealize Automation appliance and clicking the Update tab.
For example, the vRealize Automation 6.1 version string is
6.1.0.1200.
The database is created.
What to do next
“Install the IaaS Components in a Distributed Conguration,” on page 74.
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 Database Server Requirements,” on page 21.
n
Download the IaaS database installer scripts from the vRealize Automation appliance by navigating to
hps://vra-va-hostname.domain.name: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.
Installing vRealize Automation
78 VMware, Inc.