Upgrade the Jet Service Tier

Overview

When upgrading any Jet Reports component it is important to ensure that the Jet Service Tier is also upgraded to a compatible version. For example, 20.X versions of the Jet Excel Add-In can only connect to 20.X versions of the Jet Service Tier or Jet Administration Console.

As such, if you upgrade the Jet Service Tier to a 2019 R2 Build, all users on 2019 or earlier builds of the Excel Add-In will be unable to connect.

Upgrade Requirements

Before upgrading, make sure to check the following:

1. Where is the Jet Service Tier database hosted?

   Assuming you plan on using that same database, make sure you select Upgrade the existing database, not Replace at the end of the installation.

2. Which account is registered as the 'log on as' account for your Jet Service Tier service?

   To check this, open services.msc and look at the Jet Service Tier service.

   

3. When upgrading on the Jet Service Tier server, the user you are logged in as must be a sysadmin in SQL as well as a local admin.

4. Note your current Jet Service Tier settings:

   1. On the server where the Jet Service Tier is installed, open the Jet Services Administration Shell. If for any reason the Jet Services Administration Shell doesn't open automatically then you can open PowerShell as administrator run the following commands:

      cd "C:\Program Files (x86)\Jet Services\Management" .\JetServicesAdministrativeShell.ps1

   2. Run the Get-JetServiceTierSettings command and take a screenshot of your current settings to reproduce them precisely when upgrading.

5. Validate that the correct Jet Service Tier host, Jet Service Tier port, and Jet Hub URL were used.

Upgrade Notes

• We always recommend performing a SQL backup on your Jet Services database prior to upgrading in addition to creating a backup through the Jet Reports installer.

• Jet Reports 2019 R2 significantly changed the way the Jet Excel Add-In and Jet Service Tier communicate which is done via a combination of https:// and TCP connections. When connecting the 2019 R2 Jet Excel Add-In to the 2019 R2 Jet Service Tier you must use Fully Qualified Domain Names (e.g. myserver.mydomain.com ) rather than Machine Names (e.g. myserver).

• Jet Builds 21.3 and later now require the use of .NET Framework 4.8 Runtime, which is recommended to install prior to the upgrade of the Jet Service Tier as this requires the Server to be restarted.

  The installer package can be found at Download .NET Framework 4.8.

Related Articles

• Upgrading The Jet Services Database