Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Installing Jet Reports (step-by-step)

All components of the Jet Excel add-in, Jet Hub, and Jet Service Tier can be installed using a single installation program.

This guide describes how to install all the components of the Jet Reports software. If you are an end-user and you have any questions, contact your IT administrator, or send an email to jetsupport@insightsoftware.com to connect with our support team.

Installing Jet Reports

  1. Download the Jet Reports installer from the download location.

  2. Right-click the downloaded file and select Extract All .

    extract_folder.png
  3. Navigate to the Jet Reports folder and open Jet Setup.exe.

  4. The setup is launched.

    select_jet_setup.png
  5. The End User License Agreement is displayed. Scroll down to the bottom to accept it and click Agree.

    eula_agree.png
  6. Choose whether to proceed with only Client Components , only Server Components , or All Components and click Next:

    installation_options1.png

    Client Components are those applications that typically reside on a local workstation.  The Jet  Excel add-in is the primary example of this.

    Server Components are those items that typically reside on a server (for example: Jet Hub and the Jet Service Tier). These would require an administrator to implement properly.

    For more information about the components of Jet Reports and Jet Analytics (and on which computers they should be installed):.

    Watch the Video!

    Video is available in English, only.
  7. Choose the specific features you want to install and click Next.

    feature_options2.png

    Server components ( Jet Service Tier and Jet Hub ) should be installed on only one server within an organization.

    Client components ( Jet Excel Add-In and Jet Administration Console) may be installed on any number of individual workstations.

    If you do not use Jet Hub or the Jet Service Tier, you can simply choose Jet Excel Add-In and click Next to allow the installation of Jet Reports to proceed.

    From this point, several screens will be skipped if you select to only install client components.

  8. Jet Service Tier

    Specify the network connection settings that are needed by Jet Hub and click Next.

    • Jet Service Tier host: The name of the server used to access for the Jet Service Tier.

      The Jet Service Tier field will pull the fully-qualified domain name (FQDN) of the machine that the installer is running on. If this is the machine that you are installing the Jet Service Tier on, this will need to stay the same.

    • Jet Service Tier port: The port number used to access for the Jet Service Tier.

    • Jet Hub URL: The URL (web address) that will be used for connecting to Jet Hub.
      The Jet Hub URL should also usually be set to the FQDN of the server it will reside on. If you do not know what to put here, it is generally correct to copy the first box into the third box

    jst_hub_conn_settings3.png
  9. Choose which type of User Management your organization uses.  Traditionally, most organizations use Active Directory . However, the use of Microsoft 365 credentials and Microsoft Entra ID are becoming more common.

    Check with your system administrator if you are not sure.

    If you are not using the Jet Hub or Jet Service Tier, select Active Directory (do not select O365 Single Sign-on).

  10. Enter your organization's Activation Code. If you enter this code, you won't have to manually activate the Jet Excel add-in later.

    If you are installing the Jet Service Tier or Jet Hub, entering the code is required. For the other components, it's optional.

    activation_code5.png
  11. Specify the account that will be used to run the service tier ( Network Service is recommended) and click Next.
    If you do not have a dedicated Service account, Network Service already has all required permissions to run as a service. Firewall rules are required to run the Jet Service Tier and Jet Hub, so it is recommended to leave this checked.

    jst_settings6.png
  12. Jet Hub settings

    Choose whether or not to enable the required features in Microsoft's Internet Information Services automatically and click Next.

    jet_hub_settings7.png
  13. Enter the name of the SQL Server Instance and Database name that will be used to store the Service Tier information and click Next.
    The service account chosen to run the Jet Service Tier will need access to this server, and will need at least "db_datareader" and "db_datawriter" permissions on the JetServices database after installation.

    sql_server_config8.png
    To test the connection, check the drop-down listfor the database name to ensure it is displaying the databases Jet will connect with. If you get an error, the selected account most likely cannot access the SQL server that you are trying to use. You may need to select to log in with database authentication, and try a sysadmin account.
    Once the connection is working, click Next.
  14. If you've selected an existing Jet Services database in the previous step, choose to update that database to the latest version, or to replace the database, and click Next

    It is recommended to keep Backup database selected before proceeding.

    db_exists9.png
  15. Select the final installation options and click Install to begin the installation process.

    install_final_screen.png
  16. Once the installation has finished successfully, you can start using Jet!

    success_screen.png

Connecting Jet Hub with your new installation

  1. The Jet Hub requires an SSL certificate to be bound to the site. An admin user can do so through the IIS manager on the Jet Hub server.

    1. From the Connections menu in the main Internet Information Services (IIS) Manager window, select the name of the server to which the certificate was installed.
    2. Under Sites , select the Jet site to be secured with SSL.
    3. Select Jet Hub
    4. From the Actions menu (on the right), click on Bindings... This will open the Site Bindings window.
    5. In the Site Bindings window, select the Port (usually 443 ) that was specified during the installation of the Jet Hub and then click Edit ... This will open the Edit Site Binding window.
    6. Select Edit
    iis_binding_tranisition.png

    Generally, it is recommended not to change settings in this window, aside from the SSL cert. From the SSL Certificate drop-down list, select the certificate name that you just installed.

    If the Jet Hub and the Jet Service Tier are installed on the same server, the Jet Service Tier Self Signed Cert is recommended.

    iis_add_cert.png
  2. On the server where the Jet Hub is installed, after the installation has completed, you must restart the server or reset IIS.
    To reset IIS, open Command Prompt(CMD) as administrator and run the following command.

    iisreset
    iisreset.png

Published:

Installing Jet Reports (step-by-step)

All components of the Jet Excel add-in, Jet Hub, and Jet Service Tier can be installed using a single installation program.

This guide describes how to install all the components of the Jet Reports software. If you are an end-user and you have any questions, contact your IT administrator, or send an email to jetsupport@insightsoftware.com to connect with our support team.

Installing Jet Reports

  1. Download the Jet Reports installer from the download location.

  2. Right-click the downloaded file and select Extract All .

    extract_folder.png
  3. Navigate to the Jet Reports folder and open Jet Setup.exe.

  4. The setup is launched.

    select_jet_setup.png
  5. The End User License Agreement is displayed. Scroll down to the bottom to accept it and click Agree.

    eula_agree.png
  6. Choose whether to proceed with only Client Components , only Server Components , or All Components and click Next:

    installation_options1.png

    Client Components are those applications that typically reside on a local workstation.  The Jet  Excel add-in is the primary example of this.

    Server Components are those items that typically reside on a server (for example: Jet Hub and the Jet Service Tier). These would require an administrator to implement properly.

    For more information about the components of Jet Reports and Jet Analytics (and on which computers they should be installed):.

    Watch the Video!

    Video is available in English, only.
  7. Choose the specific features you want to install and click Next.

    feature_options2.png

    Server components ( Jet Service Tier and Jet Hub ) should be installed on only one server within an organization.

    Client components ( Jet Excel Add-In and Jet Administration Console) may be installed on any number of individual workstations.

    If you do not use Jet Hub or the Jet Service Tier, you can simply choose Jet Excel Add-In and click Next to allow the installation of Jet Reports to proceed.

    From this point, several screens will be skipped if you select to only install client components.

  8. Jet Service Tier

    Specify the network connection settings that are needed by Jet Hub and click Next.

    • Jet Service Tier host: The name of the server used to access for the Jet Service Tier.

      The Jet Service Tier field will pull the fully-qualified domain name (FQDN) of the machine that the installer is running on. If this is the machine that you are installing the Jet Service Tier on, this will need to stay the same.

    • Jet Service Tier port: The port number used to access for the Jet Service Tier.

    • Jet Hub URL: The URL (web address) that will be used for connecting to Jet Hub.
      The Jet Hub URL should also usually be set to the FQDN of the server it will reside on. If you do not know what to put here, it is generally correct to copy the first box into the third box

    jst_hub_conn_settings3.png
  9. Choose which type of User Management your organization uses.  Traditionally, most organizations use Active Directory . However, the use of Microsoft 365 credentials and Microsoft Entra ID are becoming more common.

    Check with your system administrator if you are not sure.

    If you are not using the Jet Hub or Jet Service Tier, select Active Directory (do not select O365 Single Sign-on).

  10. Enter your organization's Activation Code. If you enter this code, you won't have to manually activate the Jet Excel add-in later.

    If you are installing the Jet Service Tier or Jet Hub, entering the code is required. For the other components, it's optional.

    activation_code5.png
  11. Specify the account that will be used to run the service tier ( Network Service is recommended) and click Next.
    If you do not have a dedicated Service account, Network Service already has all required permissions to run as a service. Firewall rules are required to run the Jet Service Tier and Jet Hub, so it is recommended to leave this checked.

    jst_settings6.png
  12. Jet Hub settings

    Choose whether or not to enable the required features in Microsoft's Internet Information Services automatically and click Next.

    jet_hub_settings7.png
  13. Enter the name of the SQL Server Instance and Database name that will be used to store the Service Tier information and click Next.
    The service account chosen to run the Jet Service Tier will need access to this server, and will need at least "db_datareader" and "db_datawriter" permissions on the JetServices database after installation.

    sql_server_config8.png
    To test the connection, check the drop-down listfor the database name to ensure it is displaying the databases Jet will connect with. If you get an error, the selected account most likely cannot access the SQL server that you are trying to use. You may need to select to log in with database authentication, and try a sysadmin account.
    Once the connection is working, click Next.
  14. If you've selected an existing Jet Services database in the previous step, choose to update that database to the latest version, or to replace the database, and click Next

    It is recommended to keep Backup database selected before proceeding.

    db_exists9.png
  15. Select the final installation options and click Install to begin the installation process.

    install_final_screen.png
  16. Once the installation has finished successfully, you can start using Jet!

    success_screen.png

Connecting Jet Hub with your new installation

  1. The Jet Hub requires an SSL certificate to be bound to the site. An admin user can do so through the IIS manager on the Jet Hub server.

    1. From the Connections menu in the main Internet Information Services (IIS) Manager window, select the name of the server to which the certificate was installed.
    2. Under Sites , select the Jet site to be secured with SSL.
    3. Select Jet Hub
    4. From the Actions menu (on the right), click on Bindings... This will open the Site Bindings window.
    5. In the Site Bindings window, select the Port (usually 443 ) that was specified during the installation of the Jet Hub and then click Edit ... This will open the Edit Site Binding window.
    6. Select Edit
    iis_binding_tranisition.png

    Generally, it is recommended not to change settings in this window, aside from the SSL cert. From the SSL Certificate drop-down list, select the certificate name that you just installed.

    If the Jet Hub and the Jet Service Tier are installed on the same server, the Jet Service Tier Self Signed Cert is recommended.

    iis_add_cert.png
  2. On the server where the Jet Hub is installed, after the installation has completed, you must restart the server or reset IIS.
    To reset IIS, open Command Prompt(CMD) as administrator and run the following command.

    iisreset
    iisreset.png

For an optimal Community experience, Please view on Desktop