The vRealize Automation system administrator specifies server and account settings for the Windows installation server and selects a SQL database server instance and authentication method.

Prerequisites

Check Prerequisites.

Procedure

  1. On the Server and Account Settings page or the Detected Settings page, enter the user name and password for the Windows service account. This service account must be a local administrator account that also has SQL administrative privileges.
  2. Type a phrase in the Passphrase text box.

    The passphrase is a series of words that generates the encryption key used to secure database data.

    Note:

    Save your passphrase so that it is available for future installations or system recovery.

  3. To install the database instance on the same server with the IaaS components, accept the default server in the Server text box in the SQL Server Database Installation Information section.

    If the database is on a different machine, enter the server in the following format.

    machine-FQDN,port-number\named-database-instance

  4. Accept the default in the Database name text box, or enter the appropriate name if applicable.
  5. Select the authentication method.
    • Select Use Windows authentication if you want to create the database using the Windows credentials of the current user. The user must have SQL sys_admin privileges.

    • Deselect Use Windows authentication if you want to create the database using SQL authentication. Type the User name and Password of the SQL Server user with SQL sys_admin privileges on the SQL server instance.

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

  6. (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 Technet article 189067.

  7. Click Next.