Adding Analysis Services (SSAS) to your SQL Server instance–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

This is a fairly simple task, but recently I needed to test something in SSAS. I hadn’t installed this on my machine, so I had to add it. It’s simple, but worth a quick post.

The way to add SSAS (Analysis Services) to your instance is to run the setup program for SQL Server. When you do this, pick the Installation tab from the left menu.

2020-04-30 11_08_06-SQL Server Installation Center

From here, I want the first item (New SQL Server stand-along installation or add features to an existing installation). SSAS is a new feature.

When this starts moving, be sure you stop on the Installation Type screen and move the radio button to the “Add features” item.

2020-04-30 11_08_42-SQL Server 2019 Setup

The next screen is where you will check the Analysis Services box.

2020-04-30 11_09_26-SQL Server 2019 Setup

You will then get an SSAS config screen. In my case, I was testing something with the Tabular model. If you don’t know which to choose, you need to research this. Here are a couple links:

You also need an account here. I typically add my local account here for dev machines.

Don’t forget to reset the data directory if you need to do this.

2020-04-30 11_09_53-SQL Server 2019 Setup

That’s it. Let the setup run and you’ll have SSAS installed.

2020-04-30 11_12_38-SQL Server 2019 Setup

How do you check? That’s another post.


This is a really simple task, but it’s something that you should be familiar with. I needed to do this, and just documented my task, this one simple thing.

This can drive interviewers to ask about how I did this, why, what I tested, etc. This helps control the interview and the direction in which someone might query your knowledge.

As you do small tasks, write about the specific task. If you want to cover what you did after this task, write a second post.

About way0utwest

Editor, SQLServerCentral
This entry was posted in Blog and tagged , , , . Bookmark the permalink.