vRealize Automation uses a Microsoft SQL Server database to maintain information about the machines it manages and its own elements and policies.

Before you begin

About this task

The following steps describe how to create the IaaS database using the installer or populate an existing empty database. It is also possible to create the database manually. See Create the IaaS Database Manually.

Procedure

  1. Right-click the setup__vrealize-automation-appliance-FQDN@5480.exe setup file and select Run as administrator.
  2. Click Next.
  3. Accept the license agreement and click Next.
  4. On the Log in page, supply administrator credentials for the vRealize Automation appliance and verify the SSL Certificate.
    1. Type the user name, which is root, and the password.

      The password is the password that you specified when you deployed the vRealize Automation appliance.

    2. Select Accept Certificate.
    3. Click View Certificate.

      Compare the certificate thumbprint with the thumbprint set for the vRealize Automation appliance. You can view the vRealize Automation appliance certificate in the client browser when the management console is accessed on port 5480.

  5. Click Next.
  6. Select Custom Install on the Installation Type page.
  7. Select IaaS Server under Component Selection on the Installation Type page.
  8. Accept the root install location or click Change and select an installation path.

    Even in a distributed deployment, you might sometimes install more than one IaaS component on the same Windows server.

    If you install more than one IaaS component, always install them to the same path.

  9. Click Next.
  10. On the IaaS Server Custom Install page, select Database.
  11. In the Database Instance text box, specify the database instance or click Scan and select from the list of instances. If the database instance is on a non-default port, include the port number in instance specification by using the form dbhost,SQL_port_number\SQLinstance. The Microsoft SQL default port number is 1443.
  12. (Optional) : Select the Use SSL for database connection checkbox.

    By default, the checkbox is enabled. SSL provides a more secure connection between the IaaS server and SQL database. However, you must first configure SSL on the SQL server to support this option. For more about configuring SSL on the SQL server, see Microsoft Knowledge Base article 316898.

  13. Choose your database installation type from the Database Name panel.
    • Select Use existing empty database to create the schema in an existing database.

    • Enter a new database name or use the default name vra to create a new database. Database names must consist of no more than 128 ASCII characters.

  14. Deselect Use default data and log directories to specify alternative locations or leave it selected to use the default directories (recommended).
  15. Select an authentication method for installing the database from the Authentication list.
    • To use the credentials under which you are running the installer to create the database, select User Windows identity....

    • To use SQL authentication, deselect Use Windows identity.... Type SQL credentials in the user and password text boxes.

    By default, the Windows service user account is used during runtime access to the database, and must have sysadmin rights to the SQL Server instance. The credentials used to access the database at runtime can be configured to use SQL credentials.

    Windows authentication is recommended. When you choose SQL authentication, the unencrypted database password appears in certain configuration files.

  16. Click Next.
  17. Complete the Prerequisite Check.

    Option

    Description

    No errors

    Click Next.

    Noncritical errors

    Click Bypass.

    Critical errors

    Bypassing critical errors causes the installation to fail. If warnings appear, select the warning in the left pane and follow the instructions on the right. Address all critical errors and click Check Again to verify.

  18. Click Install.
  19. When the success message appears, deselect Guide me through initial configuration and click Next.
  20. Click Finish.

Results

The database is ready for use.