SQL 2016 Version Issue

JCM32 1 Reputation point
2021-05-21T14:40:02.317+00:00

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
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,232 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Lukas Yu -MSFT 5,816 Reputation points
    2021-05-24T07:16:57.37+00:00

    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