Upgrading SQL Server software to SQL Server 2019 software or SQL Server 2019 Express - Metasys - LIT-12012240 - Server - SQL Server - 13.0.50

SQL Server Installation and Upgrade Guide
Product name
SQL Server
Document type
Installation Guide
Document number
LIT-12012240
Version
13.0.50
Revision date
2024-04-09
Product status
Active

About this task

Note: Metasys Advanced Reporting System does not support SQL Server 2019.

Use the following information to upgrade any of the following versions of SQL Server software.

SQL Server Standard editions
  • SQL Server 2017
  • SQL Server 2016 SP2 or later
  • SQL Server 2014 SP3 or later
  • SQL Server 2012 SP4 or later
SQL Server Express editions
  • SQL Server 2017 Express
  • SQL Server 2016 Express
  • SQL Server 2014 SP2 Express
  • SQL Server 2012 SP4 Express

For more information on how to upgrade to SQL Server 2019, refer to the Microsoft documentation.

Procedure

  1. To upgrade a previous version of SQL Server to SQL Server 2019 Express software, click this link, download and run SQLEXPR_x64_ENU.exe.
    Note: If you do not have a required prerequisite, a box appears and indicates what is missing. Click OK, install the missing prerequisite, and then restart the procedure.
  2. In the SQL Server Installation Center window, click Installation.
  3. In the right pane, click Upgrade from a previous version of SQL Server.
  4. If required, in the Product Key window, enter the product key.
  5. Read the license terms agreement, and select the I accept the license terms check box.
  6. In the Product Updates window, a progress bar indicates the updates check.
  7. In the Upgrade Rules window, a report indicates the status of prerequisite components. If any prerequisite fails, exit the installation and fix the issue before you continue. For more information, click the Failed cell. You can ignore any warnings at this stage.
  8. In the Select Instance window, you see the names of the SQL Server instances currently installed. In the Instance to upgrade list, select the instance used by Metasys software, which is typically MSSQLSERVER. You cannot rename the database instance during an upgrade. Click Next. The upgrade skips the Select Features, and the Feature Rules windows, as you cannot select these options.
  9. In the Upgrade Progress window, you see the installation progress bar. This part of the procedure can take over 15 minutes to complete. When the Complete window appears, you see a status update for each component you installed, and an install successful message.
  10. To enable communication protocols for the databases, start SQL Server Configuration Manager.
  11. Expand Sql Server Network Configuration, and select Protocols for MSSQLSERVER.
  12. In the right pane, complete the following steps:
    1. Right-click Named Pipes and select Enable. Click OK to the warning message.
    2. Right-click TCP/IP and select Enable. Click OK to the warning message.
  13. Close the Sql Server Configuration Manager.
    Note: This version of SQL Server does not install any management tools. You must manually install SQL Server Management Studio after you complete this procedure. For more information, see Installing SQL Server Management Studio (SSMS).