Unable to Install SQL 2017 CU 28
2
votes
1
answer
1060
views
I am in the process of upgrading our SQL 2017 servers to the current CU. I have ran across two systems that won't allow me to apply the update. In the SQL installer, I see below text when I click on the SQL Instance name.
>The version of SQL Server instance MSSQLSERVER does not match the version expected by the SQL Server update. The installed SQL Server product version is 14.0.3381.3, and the expected SQL Server version is 14.0.1000.169."
I am unsure where the installer pulls the version info from. I have compared the registry against a couple of other systems and nothing is standing out as being incorrect, so not sure where it is pulling the 14.0.1000.169 value for the "expected sql version". I tried removing the previous CU so I could reapply it, but it didn't appear that it removed fully as it was still in the add/remove programs screen. Everything I have found online points to older versions where people were trying to install CUs on top of the wrong Service Packs, which doesn't apply in this case since SQL 2017 doesn't have service packs.
Any ideas would be greatly appreciated.
I am unsure where the installer pulls the version info from. I have compared the registry against a couple of other systems and nothing is standing out as being incorrect, so not sure where it is pulling the 14.0.1000.169 value for the "expected sql version". I tried removing the previous CU so I could reapply it, but it didn't appear that it removed fully as it was still in the add/remove programs screen. Everything I have found online points to older versions where people were trying to install CUs on top of the wrong Service Packs, which doesn't apply in this case since SQL 2017 doesn't have service packs.
Any ideas would be greatly appreciated.
Asked by dmcook
(21 rep)
Feb 10, 2022, 05:17 PM
Last activity: Oct 19, 2022, 02:06 PM
Last activity: Oct 19, 2022, 02:06 PM