Applying a patch is something which is part of everyone’s life in the software industry. One of my clients reported below error related to Patch Installation Error.
The version of SQL Server instance <InstanceName> does not match the version expected by the SQL Server update. The installed SQL Server product version is 11.1.3000.0, and the expected SQL Server version is 11.3.6020.0″
They said that they are not able to move ahead of below the screen.
Here is the text of the message which is shown at the bottom of the screen: There are no SQL Server instances or shared features that can be updated on this computer.
I considered support articles and found that 11.1.3000 is service pack 1 and 11.3.6020 is service pack 3. When I asked about the patch, they told that it is CU2 for SP3.
I told them that to apply any CU of service pack, we first need to apply the base service pack. Once the installed SP3, then they could install CU.
There could be two reasons of such error:
- Version of CU is not matching with the base service pack. Like the one which happened above.
- Same error can also appear if last patch was incorrectly installed. If that is the case, you can try to repair the instance and then retry the patch.
Reference: Pinal Dave (https://blog.sqlauthority.com)