Discover Analysis Service's Properties using Windows PowerShell and AMO

Part I of this article series “Microsoft Windows PowerShell and SQL Server 2008 AMO” illustrated how to install Windows PowerShell and connect to an Analysis Service Servername. Part II of this article illustrates how to use Windows PowerShell and AMO to get the various Server properties of SQL Server Analysis Service.

Let’s connect to Analysis Server using Windows PowerShell as shown below.

[Reflection.Assembly]::LoadWithPartialName("Microsoft.AnalysisServices")
$servername=New-Object Microsoft.AnalysisServices.Server
$servername.connect("PowerServer3\SQL2008")

Note: PowerServer3 is the Analysis Server with named instance SQL2008. Please replace the server name with Analysis server name in your own environment.

Read more...