What’s my SSAS version??…

How to verify your SSAS Version? Remember, we can’t run Select @@Version connecting to SSAS. Let’s see couple of ways where we can get this info.

By Connecting to SSAS from SSMS:

Right Click on the Instance and navigate to Reports->General as shown below.

We can see version information as shown below.

Or…2nd Method: Simply navigate to the folder where SSAS binaries are Installed and locate “msmdsrv.exe” and simply hover your mouse!…In my case it’s “C:\Program Files\Microsoft SQL Server\MSAS11.SQL2012\OLAP\bin”. See below

You can use the 2nd method when SSAS Service is stopped.


One thought on “What’s my SSAS version??…”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: