This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 72%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
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.
Hi @brentarsky
because the install thinks that some components still have the SP2 version.
What is the actual version now?
The SQL Server 2016 SP3 upgrade completed without error and will not rerun
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\130\Bootstrap\Setup\PatchLevel
13.3.6404.1
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\130\SQLServer2016\CurrentVersion\Version
13.3.6404.1
but the SQL Server 2022 upgrade reports
Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered Configured
SQL Server 2016 MSSQLSERVER MSSQL13.MSSQLSERVER Database Engine Services 1033 Express Edition 13.2.5888.11 No Yes
SQL Server 2016 MSSQLSERVER MSSQL13.MSSQLSERVER SQL Server Replication 1033 Express Edition 13.2.5888.11 No Yes
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?
Microsoft SQL Server 2016 (SP2-CU17) (KB5001092) - 13.0.5888.11 (X64) Mar 19 2021 19:41:38 Copyright (c) Microsoft Corporation Express Edition (64-bit) on Windows 10 Enterprise 2016 LTSB 10.0 <X64> (Build 14393: )
Here is the message that I get from the SQL Server 2022 upgrade
The SQL Server 2016 features that have been selected to be upgraded to SQL Server 2022 are not at the required service pack. To continue with this upgrade, install SQL Server 2012 Service Pack 3 or later to the selected instance and the shared features.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 4%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHB%3C/text%3E%3C/svg%3E)
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?