A vRealize Automation system administrator can install the IaaS schema on an empty database. This installation method provides maximum control over database security.
Verify the database installation prerequisites. See IaaS Database Server Requirements.
Download the IaaS database installer scripts from the vRealize Automation appliance by navigating to https://vra-va-hostname.domain.name:5480/installer/.
- Navigate to the Database directory within the directory where you extracted the installation zip archive.
- Extract the DBInstall.zip archive to a local directory.
- Log in to the Windows database host with sysadmin privileges within the SQL Server instance.
- Edit CreateDatabase.sql and replace all instances of the variables in the table with the correct values for your environment.
Table 1. Database Values
Name of the database, such as vra. Database names must consist of no more than 128 ASCII characters.
Path to the data directory for the database, excluding the final slash.
Path to the log directory for the database, excluding the final slash.
- Review the settings in the DB Settings section of CreateDatabase.sql and edit them if needed.
The settings in the script are the recommended settings for the IaaS database. Only ALLOW_SNAPSHOT_ISOLATION ON and READ_COMMITTED_SNAPSHOT ON are required.
- Open SQL Server Management Studio.
- Click New Query.
An SQL Query window opens.
- On the Query menu, ensure that SQLCMD Mode is selected.
- Paste the entire modified contents of CreateDatabase.sql into the query pane.
- Click Execute.
The script runs and creates the database.