7.4

Table Of Contents
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 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 sufficient rights to create and drop databases sysadmin
privileges in the SQL Server instance.
4 Review the database deployment scripts as needed. In particular, review the settings in the
DBSettings section of CreateDatabase.sql and edit them if necessary.
The settings in the script are the recommended settings. 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 59. Database Values
Variable Value
db_server Specifies 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 final
slash.
log_dir Path to the log directory for the database, excluding the final 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.
Installing vRealize Automation
VMware, Inc. 76