7.0

Table Of Contents
Table 413. Choosing an IaaS Database Scenario
Scenario Procedure
Create the IaaS database manually using the provided database
scripts. This option enables a database administrator to review
the changes carefully before creating the database.
Create the IaaS Database Manually.
Prepare an empty database and use the installer to populate the
database schema. This option enables the installer to use a
database user with dbo privileges to populate the database,
instead of requiring sysadmin privileges.
Prepare an Empty Database.
Use the installer to create the database. This is the simplest
option but requires the use of sysadmin privileges in the
installer.
Create the IaaS Database Using the Installation Wizard.
Create the IaaS Database Manually
The vRealize Automation system administrator can create the database manually using VMware-provided
scripts.
Prerequisites
n
.NET 4.5.1 or later must be installed on the SQL Server host.
n
Use Windows Authentication, rather than SQL Authentication, to connect to the database.
n
Verify the database installation prerequisites. See IaaS Database Server Requirements.
n
Download the IaaS database installer scripts from the vRealize Automation appliance by navigating to
https://vra-va-hostname.domain.name: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
Installing vRealize Automation
VMware, Inc. 78