SQL Server Express 2022 upgrade fails on SQL Server Express 2016 SP3

brentarsky 0 Reputation points
2023-10-11T17:53:10.2566667+00:00

We are currently using SQL Server Express 2016 SP3 on all of our systems, but some systems have been upgraded from SQL Server Express 2016 SP2 and others started with SQL Server Express 2016 SP3.

The systems that started with a fresh install of SQL Server Express 2016 SP3 will upgrade to SQL Server Express 2022 without an error.

The systems that were upgraded from SQL Server Express 2016 SP2 to SQL Server Express 2016 SP3, cannot be upgraded to SQL Server Express 2022, because the install thinks that some components still have the SP2 version.

How can I correct this problem and complete the upgrade to SQL Server Express 2022. I tried rerunning the SQL Server Express 2016 SP3 upgrade and it will not start because there is nothing to upgrade.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,860 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 41,011 Reputation points
    2023-10-12T05:50:28.2166667+00:00

    A lot of words with only less informations. What does the query

    SELECT @@VERSION
    

    and the discovery report return? Validate a SQL Server Installation

    And more important: Which exact and completly message do you get?


  2. Hawkins, Brent (GE HealthCare) 0 Reputation points
    2023-11-02T13:47:10.62+00:00

    I know there is an option called /SKIPRULES. Is there a rule id to use that will skip the check of the 2016 service pack?

    0 comments No comments