Report Portal

Q: How can I identify version/build of Microsoft SSAS 2005/2008 on my server?

Q: How can I identify version/build of SSAS 2005/2008 on my server?

A: If your SSAS services is running, then start SQL Server Management Studio (SSMS) and connect to Analysis services instance. In the object tree you will see your server name and information about that server:

<mashine-name>(Microsoft Analysis Server 10.0.1787.0 - <mashine-name>\<User-name>) 

In my sample above Microsoft Analysis Server has build 10.0.1787.

If you SSAS service is not running, then go to the folder where binaries SSAS files are located (by default C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\bin) and check version of the file msmdsrv.exe. This version represent SSAS build.

SQL Server Analysis Services 2005 builds:

Build  Date  Notes 
9.00.1399     SQL 2005 RTM
9.00.2047    SQL 2005 SP1
9.00.3042    SQL 2005 SP2
9.00.3161    SQL 2005 SP2 CU1
9.00.3175    SQL 2005 SP2 CU2
9.00.3186 2007 Sep  SQL 2005 SP2 CU3
9.00.3200 2007 Oct  SQL 2005 SP2 CU4
9.00.3215 2007 Dec  SQL 2005 SP2 CU5
9.00.3228 2008 Feb  SQL 2005 SP2 CU6
9.00.3239 2008 Apr  SQL 2005 SP2 CU7
9.00.3257 2008 Jun  SQL 2005 SP2 CU8
9.00.3282 2008 Aug   SQL 2005 SP2 CU9
9.00.3294 2008 Oct  SQL 2005 SP2 CU10
9.00.3301 2008 Dec  SQL 2005 SP2 CU11
9.00.3315 2009 Feb  SQL 2005 SP2 CU12
9.00.4035 2009 Dec  SQL 2005 SP3

9.00.4207

2007 Dec  SQL 2005 SP3 CU1
9.00.4211 2009 Feb  SQL 2005 SP3 CU2
     

SQL Server Analysis Services 2008 builds:

Build

Date 

Notes 

10.00.1600.22  Aug, 2008 SSAS 2008 release 
10.00.1755  Sep 12, 2009 Hotfix
10.00.1767  Sep 22, 2008 SQL 2008 CU 1
10.00.1771  Oct 27, 2008 Hotfix
10.00.1779  Nov 17, 2008 SQL 2008 CU 2
10.00.1787  Jan 19, 2009 SQL 2008 CU 3
10.00.1788  Jan 28, 2009 Hofix
10.00.1790  Feb 4, 2009 Hofix
10.00.1798  Mar 16, 2009 SQL 2008 CU 4
10.00.2531  Apr 7, 2009 SQL 2008 - SP1
10.00.2710  Apr 16, 2009 SQL 2008 - SP1, CU1
10.00.1806  May 19, 2009  SQL 2008 CU5
10.00.2714  May 19, 2009  SQL 2008 SP1, CU2
     
     
     

 

Tags: faq, management

 

2007-2015 VidasSoft Systems Inc.