7.3

Table Of Contents
Table 58. 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.
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
Install Microsoft .NET Framework 4.5.2 or later 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 SQL Server Host.
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
Installing vRealize Automation
VMware, Inc. 74