Unable to upgrade SQL Server in Database Administration in version 25.1 and later due to Reporting Services being installed
Description

Unable to upgrade SQL Server in Database Administration in version 25.1 and later due to Reporting Services being installed

Cause

When SQL Server was installed (manually, not through Database Administration), the option to install Reporting Service was checked in the install options. Sage cannot up automatically update an instance with Reporting Services as the update to SQL 2019 and later prompts uninstall this service.

Resolution

There are two options:

Option 1: Uninstall Reporting Services for the instance you are attempting to upgrade, restart the machine, then run the SQL Upgrade in Database Administration again

Important Note: This will require restarting your server.

  1. In Windows Control Panel, click Programs and Features.
  2. In Programs and Features select Microsoft SQL Server 2014 (64-bit).
  3. Right-click on Microsoft SQL Server 2014 (64-bit) and select Uninstall/Change, Remove
  4. In the uninstall wizard, select the instance that includes the Reporting Services instance feature RS.

  1. After you select the instance, select the Reporting Services feature.

  1. Complete the wizard.
  2. Restart the server.



Option 2: Manually download the upgrade installer from Microsoft and run the installer. Note that during the installation, you will be prompted to uninstall Reporting Services before the installation can proceed.

Note: This only applies when upgrading SQL Server 2014 and 2016. Later versions do not have the option to install Reporting Services.

Steps to duplicate
Related Solutions