You can one or more SQL Server instance for the Horizon domain. For example, you can use a different SQL Server for events and runtime data.

Procedure

  1. In the Add SQL Servers section, select Add manually to add SQL Servers information manually or Import from JSON template to import SQL Servers from a JSON file.
    • To add SQL Servers manually, follow the steps below.
      1. Provide the following information.
        Field Name Information to be Entered
        Alias Enter an alias for the SQL Server.
        FQDN Enter the FQDN for the SQL Server.
        SQL Instance Name Enter name of the the SQL Server instance to be used for the Horizon domain.
        SQL Port Enter the port number to connect to the SQL Server. The default port is 1433.
        Database Username Enter the user name to connect to the SQL Server.
        Database Password Enter the password for the database user name.
        Confirm Database Password Re-enter the password for the database user name.
      2. Click Add.

        The SQL Servers is added to the SQL Servers table.

      3. Repeat steps a and b for additional SQL Servers as required.
    • To import SQL Servers from a JSON file, click Browse, select the file, and click Upload.

      SQL Servers from the JSON file are added to the SQL Servers table.

  2. Click Next.