Solution Properties
Solution ID:
230523221823020
Last Modified Date:
Tue Mar 03 19:32:14 UTC 2026
Taxonomy Path:
Category//Installation//Install update or patch
Author:
[email protected]
Unable to upgrade to SQL Server 2019 or later in Database Administration
Description
Cause

The customer didn't install SQL Server from Database Administration and selected the Reporting Services component. The Reporting Services (RS) component prevents upgrading SQL Server.

Resolution

 CAUTION: Consult with your IT specialist before proceeding, as the Reporting Service can be in use. The procedure below also requires a server restart. 

Uninstall Reporting Services through the Windows Control Panel

  1. In the Windows Control Panel, click Programs and Features.
  2. 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.

Remove SQL Server 2014 select Instance window.

  1. Select the Reporting Services feature after choosing the SQL instance to remove from.

Remove SQL Server 2014 Select Features window.

  1. Complete the wizard.
  2. Restart the server.
  3. Connect to Sage 100 Contractor Database Administration and upgrade SQL Server.
[BCB:154:Chat 100 Contractor US:ECB]

 

 

 

 

 

Steps to duplicate
Related Solutions