Ask Learn
Preview
Ask Learn is an AI assistant that can answer questions, clarify concepts, and define terms using trusted Microsoft documentation.
Please sign in to use Ask Learn.
Sign inThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
As you may have noticed by now the servicing model for SQL Server 2017 has changed. For details see:
One of the less known facts is that sql server and SSAS build numbers released in SQL Server 2017 cumulative updates do not match anymore.
The issue is described here:
The article describes a method that allows to identify the SSAS build number from the corresponding CU KB articles.
However, the method is rather cumbersome and my quick search on the net did not find any page that provides an option for easy translation.
Therefore I’ll try to maintain a table that allows for easy translation between KB articles, CU numbers, sql build numbers, and SSAS build numbers.
build |
build number sql |
build number SSAS * |
CU release date |
KB article |
RTM |
14.0.1000.169 |
|
October 2, 2017 |
- |
CU1 |
14.0.3006.16 |
14.0.1.439 |
October 24, 2017 |
|
CU2 |
14.0.3008.27 |
14.0.1.440 |
November 28, 2017 |
|
CU3 |
14.0.3015.40 |
14.0.202.1 |
January 04, 2018 |
|
CU4 |
14.0.3022.28 |
14.0.204.1 |
February 20, 2018 |
|
CU5 |
14.0.3023.8 |
14.0.204.1 |
March 20, 2018 |
|
CU6 |
14.0.3025.34 |
14.0.204.1 |
April 17, 2018 |
|
CU7 |
14.0.3026.27 |
14.0.213.1 |
May 23, 2018 |
|
CU8 |
14.0.3029.16 |
14.0.223.1 |
June 21, 2018 |
|
CU9 |
14.0.3030.27 |
14.0.223.1 |
July 18, 2018 |
|
CU10 |
14.0.3037.1 |
14.0.226.1 |
August 27, 2018 |
*Note that KB articles list the SSAS file version in format 2017.140.XX.X , whereas file explorer + SSMS will display format 14.0.XXX.X
CU4/5/6 and CU8/9 have same build number for SSAS component.
Ask Learn is an AI assistant that can answer questions, clarify concepts, and define terms using trusted Microsoft documentation.
Please sign in to use Ask Learn.
Sign in