Check the edition and server mode of Analysis Services (SSAS)

It is very common to forget the mode of analysis services installed on your sandbox machine particularly since tabular mode is getting used in more recent projects, here is a snippet of ps code which can be run to find it out :

## Add the AMO namespace
$loadInfo = [Reflection.Assembly]::LoadWithPartialName(“Microsoft.AnalysisServices”)

## Connect and get the edition of the local server
$connection = “localhost”
$server = New-Object Microsoft.AnalysisServices.Server
$server.connect($connection)

#Write-Output $server

Write-Output ‘———————————–‘
Write-Output (“`nServer: {0}`nEdition: {1}`nBuild: {2}`nServerMode: {3}`n” -f
$server.Name, $server.Edition, $server.Version, $server.ServerMode)
Write-Output ‘———————————–‘

Or if you have SSMS installed, you can connect to Analysis services drop-down and then connect, then right click on server properties:

Leave a Comment


NOTE - You can use these HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>