BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
Before you can get started with tabular SSAS, you need to check you have Analysis Services (tabular model) installed on your computer. This blog also shows you how to run and configure Visual Studio, and how to create your first tabular project.
- Getting started with tabular model Analysis Services
- Checking you have Analysis Services Tabular running (this blog)
- Running and Customising Visual Studio
- Creating a tabular project in Visual Studio
This blog is part of our online SSAS Tabular tutorial; we also offer lots of other Analysis Services training resources.
Posted by Andy Brown on 11 November 2015
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Checking you have Analysis Services Tabular running
You can check what SSAS services you have running using either or both of SQL Server Configuration Manager and SQL Server Management Studio.
Checking using Configuration Manager
You can use SQL Server Configuration Manager (among other tools) to check you have an instance of SQL Server Analysis Services (tabular model) running:

Choose this option to run SQL Server Configuration Manager.
You can now see if you have an instance of Analysis Services running:

Not only is this instance of SSAS running (which is good news), but it's set to start automatically when you turn on your computer.
Of course, this could be running in multi-dimensional mode, so you now need to check this in Management Studio!
Using SSMS to check the type of Analysis Server instance running
You can now run Management Studio to check on your SSAS instance:

If you don't know how to run Management Studio, you probably shouldn't be reading this blog!
You can now choose to connect to Analysis Services:

Choose to connect to your Analysis Services database.
If the icon next to your server looks like this, you're using tabular SSAS:

The icon for a tabular database looks like this.
Compare this with the other possible icons (taken from this StackOverflow article):

The icons for multi-dimensional, tabular and PowerPivot modes respectively.
OK - things are looking good, so let's now use Visual Studio and customise its settings.
- Getting started with tabular model Analysis Services
- Checking you have Analysis Services Tabular running (this blog)
- Running and Customising Visual Studio
- Creating a tabular project in Visual Studio