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 response to “What’s my SSAS version??…”

  1. bloger7791 Avatar

    It’s very useful. Thanks

Leave a comment

I’m Sreekanth

Welcome to MSSQLTREK, my little corner of the internet where I geek out about SQL Server, databases, and all things cloud. This blog is my space to share lessons learned, cool tips, real-world troubleshooting stories, and the occasional deep dive into data and performance. Whether you’re a fellow Cloud Architect, DBA, Developer, or just cloud-curious, come along for the ride — let’s explore, optimize, and build awesome data solutions together!

Let’s connect