Udostępnij za pośrednictwem


SSAS 2017 servicing model and build numbers

 

As you may have noticed by now the servicing model for SQL Server 2017 has changed. For details see:

https://blogs.msdn.microsoft.com/sqlreleaseservices/announcing-the-modern-servicing-model-for-sql-server/ 

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:

https://docs.microsoft.com/en-us/sql/analysis-services/instances/analysis-services-component-version?view=sql-server-2017&viewFallbackFrom=sql-server- 

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

KB4038634

CU2

14.0.3008.27

14.0.1.440

November 28, 2017

KB4052574

CU3

14.0.3015.40

14.0.202.1

January 04, 2018

KB4052987

CU4

14.0.3022.28

14.0.204.1

February 20, 2018

KB4056498

CU5

14.0.3023.8

14.0.204.1

March 20, 2018

KB4092643

CU6

14.0.3025.34

14.0.204.1

April 17, 2018

KB4101464

CU7

14.0.3026.27

14.0.213.1

May 23, 2018

KB4229789

CU8

14.0.3029.16

14.0.223.1

June 21, 2018

KB4338363

CU9

14.0.3030.27

14.0.223.1

July 18, 2018

KB4341265

CU10

14.0.3037.1

14.0.226.1

August 27, 2018

KB4342123

 

 

*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.