question

JDSchmidt-3141 avatar image
1 Vote"
JDSchmidt-3141 asked Criszhan-msft commented

Can't upgrade SQL Server 2016 to latest CU update.

Hi, I am trying to install software that requires sql server 2016 SP2 with CU 11 (13.0.5998.27). It fails because it says I have 13.0.5103.6. I downloaded the latest CU and tried to install that however everything is greyed out and can't be selected (see screenshots below). I did confirm that sql server is on x64 and I am installing the correct architecture. However when I compare the version in the mssms I get the older version and when I go through the setup media it is showing the updated CU. Any idea how to fix or debug this? Thanks.

59250-screen-shot-2021-01-21-at-114400-am.png59311-screen-shot-2021-01-21-at-125723-pm.png59285-screen-shot-2021-01-21-at-114520-am.png59293-screen-shot-2021-01-21-at-11132-pm.png59159-screen-shot-2021-01-21-at-44315-pm.png59266-screen-shot-2021-01-21-at-44409-pm.png
59160-screen-shot-2021-01-21-at-44816-pm.png59321-screen-shot-2021-01-21-at-44526-pm.png


sql-server-general
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @JDSchmidt-3141,

Can you show the Summary_xx.txt file under the C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\2021xxxxxx. The 2021xxxxxx mean the time you installed the CU.

And check the installed updates for sql server 2016 under Control Panel>Programs and Features>View installed updates

0 Votes 0 ·

Thank you for your response. Here is the attached summary.txt It shows user cancelled but that could be because I tried to install it again. Also attached is a screenshot of the installed updates. Thank you.
59717-summary.txt
[1]



59687-screen-shot-2021-01-22-at-101944-am.png


0 Votes 0 ·
ErlandSommarskog avatar image
1 Vote"
ErlandSommarskog answered ErlandSommarskog commented

I think the story is that you have been lead astray on the GDR train. That is, you have SQL 2016 SP2 without CU, but you have installed a few GDRs. It seems that in this situation there is no upgrade path to later CUs. I have experienced the same with an instance of SQL 2014 SP3, which I can't easily get to CU4.

It is possible that if you uninstall the GDRs that you can come back to the train station and catch the CU train and install CU15, the latest CU (to which there also is a GDR). I have not tried this myself. (The instance I have problems with is a toy instance at home.)

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you this did work. I had to uninstall the Security update and then reinstall the CU and I was able to get it to work. I appreciate your help.

0 Votes 0 ·

I'm glad to hear that the idea worked out. Let's see if I can get myself together to fix my SQL 2014 instance. There is more than one GDR I need to uninstall...

0 Votes 0 ·
OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered JDSchmidt-3141 commented

It fails because it says I have 13.0.5103.6

And that's right, as one of the other screenshot also reports, you SQL Server is on that build version.

59503--temp.png

Which SQL CU installer did you used/which download link?


-temp.png (1.6 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks for your response here! Here is the CU link I tried to install https://www.microsoft.com/en-us/download/details.aspx?id=56975 Filename: SQLServer2016-KB4577775-x64.exe Here is what it says when I try to install it: 59666-screen-shot-2021-01-22-at-100803-am.png


0 Votes 0 ·
Shashank-Singh avatar image
0 Votes"
Shashank-Singh answered

Don't confuse yourself with version of DB engine and and that of SSMS. The version of DB engine is that of 13.0.5103.6 while that of SSMS is 14..0.17289. Both are different and SSMS is totally different product from DB engine, its different installation now and does not comes with DB engine.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Criszhan-msft avatar image
0 Votes"
Criszhan-msft answered Criszhan-msft commented

Hi @JDSchmidt-3141,

The log files and screenshots indicate that the version of your SQL Server 2016 instance is now 13.2.5103.6. The current situation is that you cannot install any CU(for SQL Server 2016 SP2) for this instance.

I suggest you uninstall this Security update(KB4583460) first , and reinstall the CU 15 for SQL Server 2016 SP2, finally install the Security update for SQL Server 2016 SP2 CU15(KB4583461)

Check the Microsoft SQL Server Versions List for more details.
https://sqlserverbuilds.blogspot.com/#sql2016x



· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

This was also the correct answer I just didn't get to the last one in time, but uninstalling and installing CU resolved my problem. Thank you.

1 Vote 1 ·

Hi,
thank you for your reply.
Glad to hear that your problem has been resolved.
Best Regards,

0 Votes 0 ·