question

JCM32-9948 avatar image
0 Votes"
JCM32-9948 asked LukasYu-msft commented

SQL 2016 Version Issue

I was contacted by implementers as they were attempting to install SQL Server Analysis Services. From the Database server they were getting:

98685-error-from-implementer.png

Select @@Version shows:
In SSMS the instance shows the build number as 13.0.5103.6.

You may notice it is SP2-GDR versus just SP2. Microsoft shows the latest version is SP2 CU17 with build number 13.0.5888.11.

In searching, the following article shows build number 13.0.5103.6 As current for SQL Server 2016 SP2 GDR as of 1/12/2021.
https://www.microsoft.com/en-us/download/details.aspx?id=102622

We tried to update the BI Database server but noticed we could not select the Instances at the Select Features screen and Select All had no effect. Note the description section:



The discovery report shows:
98676-sql-discovery-report.png



Thoughts please? I am not sure why the report shows 13.2.5103.6 versus the @@version query of 13.0.5103.6. However, it does appear R Services, sql_inst_mr and Analysis Services are down-rev.


sql-server-analysis-services
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.

1 Answer

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

Hi,


This happens due to the GDR update. If you installed GDR security updates , you could not follow the CUs of SQL Server 2016. This is the product design.

I would suggest you to uninstall the GDR update in window control panel. Then, install the newest CU17. CU packages are, in my opinion, better choice for most users. With newest CU17, your implementers should not have further problems.

See similar issue in here : Can't upgrade SQL Server 2016 to latest CU update.

Regards,
Lukas


· 3
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.

Hello Lukas,

Thank you for the feedback, we wondered about that. However, this server is also in an AAG and the other members have SP2-GDR as well. Can a replica running standard SP2 CU17 for example be in the AAG with the other members run SP2-GDR?

Regards,
John

0 Votes 0 ·

Hi John,

Yes, for replica, you could use SP2 GDR along with SP2 CU17.


And still I would recommend to upgrate them both to CU 17.

0 Votes 0 ·

Have you resolved your issue ? Could we offer more help?

0 Votes 0 ·