New answers tagged

0

We never found out what was causing the service to stop, but we were able to prevent it from happening. We put a Deny on the Stop permission for SSAS service for the SQL Server (not SSAS) service account user. So it seems something acting as the SQL Server's service account user was issuing the Stop command for the SSAS account. This was a while ago, and ...


3

You could use powershell to connect to the database and list a lot of properties. Use this script to find out what properties you can get from a database: $loadInfo = [Reflection.Assembly]::LoadWithPartialName("Microsoft.AnalysisServices") $server = New-Object Microsoft.AnalysisServices.Server $server.connect("localhost") $Server.Databases | Get-Member ...


1

No SQL Server version mentioned, just in case that makes a difference. However, if you have sufficient rights you can connect to the server using the Object Explorer / Connect drop down and choose "Analysis Services..." rather than "Database Engine...". This will expand to allow you to see some details of the Analysis Services databases. Just by using ...


1

The easiest way is : using SSMS -- connect to instance --> reports -> standard reports --> General There are other ways as well - How to find Analysis Services Server Version ?.



Top 50 recent answers are included