Installation prerequisites

Note

Make sure to review our Requirements and compatibility to confirm that this configuration is appropriate for your organization.

  1. Obtain Querona installation package from retail or OEM channels, and copy binaries into selected folder on the target computer or accessible network share.

  2. Obtain Querona license (XML). If license is not provided in post-installation steps, only Querona Administrative Portal will be functional. No database connections can be made until a valid license is provided.

  3. Prepare a single computer that satisfies the Requirements and compatibility for Querona.

  4. If SSL communication is required, install the certificate into local machine certificate store in Windows.

  5. Decide how to deploy Querona and Apache Spark metabases: automatically using the installer or manually (advanced).

    Manual installation of Querona and Apache Spark metabases requires more preparation and is recommended for advanced configuration not supported natively by installer.

  6. Ensure you have a recent backup of existing metabases.

  7. Use the built-in engines OR set up a supported version of SQL Server to host Querona and Apache Spark metabases.

    Querona supports a Microsoft SQL Server instance to store metadata information. If you do not have a database server available, you may configure a local SQL Server Express, which is a free, entry-level database server from Microsoft.

Note

Recommended SQL Server installation procedure is described in Installation of SQL Server Engine.

Ensure that:

  • Database server supports SQL Server Mixed Mode Authentication. Documentation of how to change SQL Server Authentication mode of an already installed SQL Server is available at Microsoft docs.
  • Database server TCP port is enabled.
  • Account you are installing Querona with is a member of the SysAdmin server role in SQL Server. After installation SysAdmin privilege can be revoked.
  • For automatic metabase installation or upgrade to work, files Querona.dacpac and SparkMetastore.dacpac are present in the same directory as MSI installation package.

Note

Write down the information about database server chosen to host metabases and Querona service user, because it will be required at the later stages.

If you decide to use manual database deployment or upgrade of Querona metabase and Apache Spark metabase, please navigate to Manual installation of Querona and Apache Spark metabases on SQL Server.

If all prerequisites are met, please proceed with Querona server installation procedure.