Saturday, December 14, 2019

Update Microsoft SQL Server 2016 SP2 fail.

Install offline file: SQLServer2016-KB4527378-x64.exe
When i try to update SqlServer2016 Sp1 to SP2 (CU11) it fail. and the error msg show

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 13.0.4001.0, and the expected SQL Server version is 13.2.5026.0.

So  I try to downgrade to 13.0.1601.5 RTM but it is still not match error.
Try to update another patch and  it worked for SQLServer2016-KB4037357-x64.exe (13.0.1708.0 RTM). but from here wanna upgrade to SP2(CU11) is still error.

Then i try install this  and its passed(SQLServer2016SP2-KB4052908-x64-ENU.exe).

Version show as:
Microsoft SQL Server 2016 (SP2) (KB4052908) - 13.0.5026.0 (X64)   Mar 18 2018 09:11:49   Copyright (c) Microsoft Corporation  Standard Edition (64-bit) on Windows Server 2016 Standard 10.0 (Build 14393: ) 

Then restart and install the above patch. Done!