How to determine which Analysis Services edition is installed

Hi,

How can I determine what edition (standard or enterprise) of Analysis Services is installed on a server?

thanks

Lyn

I guess that the version of AS will be the same as the version of SQL Server, which you can determine by executing the following SQL-query:

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

Source: http://support.microsoft.com/kb/321185

|||

No, since only AS was installed on the server.

|||

Then you have to connect to the AS server using SQL Management Studio, highlight the server and then click Report in the Summary tab.

You'll see a reporting services report with the info:

Server: COMPUTERNAME(\INSTANCE) 4/19/2007 15:19 Edition: Developer Version: 9.00.2047.00

|||

The Analysis server is version 2000 though.

Thanks

|||

Look at this registry key value:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.2\Setup\Edition

|||

On a named instance this value is at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<INSTANCE NAME>\Setup

Else, here is a feature comparison: http://msdn2.microsoft.com/en-us/library/aa175266(SQL.80).aspx

Enterprise Edition has support for linked cubes, user-defined partitions etc.