When upgrading any Jet Reports components 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.
Upgrading is fairly straightforward, there are just a few requirements you should be aware of:
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 install.
What account is the 'log on as' account for your Jet Service Tier service? You can check this by opening services.msc and looking at the Jet Service Tier service.
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.
Open the Jet Services Administration Shell and run the Get-JetServiceTierSettings command on the server where the Jet Service Tier is installed, then take a screenshot of your current settings to reproduce them precisely when upgrading.
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"
Validate that the correct Jet Service Tier host, Jet Service Tier port, and Jet Hub URL were used.
We always recommend performing a SQL backup on your Jet Services database prior to upgrading in addition to the backup which can be created 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.