This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 32%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
I was contacted by implementers as they were attempting to install SQL Server Analysis Services. From the Database server they were getting:
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:
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.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 9%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELY%3C/text%3E%3C/svg%3E)
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
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
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.
Have you resolved your issue ? Could we offer more help?