QPR UI Installation Checklist

From Mea Wiki
Jump to navigation Jump to search

This checklist for QPR UI installation and configuration contains all the needed steps to complete a QPR UI installation. The steps need to be done in the listed order.

Installation step Description
1. QPR UI system requirements Check that your hardware and software infrastructure fulfills the QPR UI system requirements. Especially note Microsoft OLE DB Driver 18 for SQL Server and .Net Framework 3.5 which need to be installed before installing QPR UI.
2. SQL Server configuration Make the needed configurations for the SQL Server where the QPR UI database will be located. SQL Server configuration must be done before running the QPR UI installer.
3. QPR UI installer Run the QPR UI installer. The installer download link can be found in the home page of this wiki. Settings in the wizard pages 6, 8, 9 and 10 can also be done after the installation, if the needed information is not available during the installation. (For advanced installation scenarios, you can alternatively use the silent installation procedure.)
4. IIS as reverse proxy for QPR UI Configure IIS to route through QPR UI traffic.
5. Detailed error messages in IIS Enable detailed error messages for IIS.
6. Hardening security Go through the instructions for hardening the security for QPR UI.
7. Common QPR Authentication Configure the Common QPR Authentication, which enables to open QPR Suite portal from QPR UI and vice versa without a separate login. The Common QPR Authentication is mandatory if using the federated authentication (the next step).
8. Federated authentication Configure the federated authentication for QPR UI, if there is a federated authentication identity provider (IdP) available in your organization, such as Active Directory Federation Services (ADFS). This enables to use your organization's centralized identity management system without managing user accounts separately in QPR products. Note that QPR UI is not directly compatible with the LDAP protocol.
9. QPR Suite Reporting Add-on It is recommended to install QPR Suite Reporting Add-on. To use the QPR Suite Reporting Add-on Expressions Language in QPR UI, you need to configure the QPR_REPORTING_EXPRESSIONS_WEB_SERVICE_LOCATION setting in QPR UI configuration table.
10. System settings You might need to change QPR UI system settings stored in QPR UI database. Note that database connection settings are in the Payara Administration Console.