Difference between revisions of "QPR UI Installation Checklist"
Jump to navigation
Jump to search
| (14 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | This | + | 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. |
| + | |||
| + | <div class="downloadButton" style="width:240px;margin:5px 0px 5px 20px;">[[QPR_Product_Downloads|Download QPR UI]]</div> | ||
{| class="wikitable" | {| class="wikitable" | ||
| − | !''' | + | !'''Installation step''' |
! '''Description''' | ! '''Description''' | ||
|- | |- | ||
| − | ||[[QPR UI System Requirements|QPR UI system requirements]] | + | ||1. [[QPR UI System Requirements|QPR UI system requirements]] |
| − | ||Check that your hardware and software infrastructure fulfills the 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. |
|- | |- | ||
| − | ||[[SQL Server Configuration in QPR UI|SQL Server configuration]] | + | ||2. [[SQL Server Configuration in QPR UI|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. | ||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 Windows Installer|QPR UI installer]] |
||Run the QPR UI installer. The installer download link can be found in the [[QPR_UI_Wiki|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 in QPR UI|silent installation procedure]].) | ||Run the QPR UI installer. The installer download link can be found in the [[QPR_UI_Wiki|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 in QPR UI|silent installation procedure]].) | ||
|- | |- | ||
| − | ||[[ | + | ||4. [[Setting up IIS as Reverse Proxy for QPR UI|IIS as reverse proxy for QPR UI]] |
| − | ||Configure IIS to | + | ||Configure IIS to route through QPR UI traffic. |
|- | |- | ||
| − | ||[[Enable Detailed Error Messages in IIS| | + | ||5. [[Enable Detailed Error Messages in IIS|Detailed error messages in IIS]] |
||Enable detailed error messages for IIS. | ||Enable detailed error messages for IIS. | ||
|- | |- | ||
| − | ||[[ | + | ||6. [[QPR UI Security Hardening|Hardening security]] |
| − | ||Go through the instructions | + | ||Go through the instructions for hardening the security for QPR UI. |
| − | |||
| − | |||
| − | |||
|- | |- | ||
| − | ||[[Common QPR Authentication]] | + | ||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). |
|- | |- | ||
| − | ||[[Federated Authentication in QPR UI|Federated authentication]] | + | ||8. [[Federated Authentication in QPR UI|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. |
|- | |- | ||
| − | ||[[QPR | + | ||9. [[QPR Reporting Add-on#Installation|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 UI System Settings#Settings for QPR Product Locations|QPR_REPORTING_EXPRESSIONS_WEB_SERVICE_LOCATION]] setting in QPR UI configuration table. |
|- | |- | ||
| − | ||[[QPR UI | + | ||10. [[QPR UI System Settings|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 Configuration in QPR UI#Changing Database Connection Settings|Payara Administration Console]]. |
|} | |} | ||
[[Category: QPR UI]] | [[Category: QPR UI]] | ||
Latest revision as of 15:01, 15 January 2020
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. |