How to install SSAS (Sql Server Analysis Services)

Many times you do not initially install SSAS when you build your Sql Server instance.  This posting will show you how to install.  There will be future articles concerning Tabular Models and the cool things you can do with them.

If we look at the services that are installed on my server, you can see there are not any analysis services installed.



To proceed, you first need to have Sql Server Data Tools installed on your server.  After you have that installed, you can open Sql Server 2016 installation Center.


Clicking that opens the following prompts.  We want to add features to an existing database, so select the top option.



Click the box to add to an existing instance, since we already have a Sql Server instance installed.



Select Analysis Services as shown below.



Click next.



Select Tabular Mode, since that is the mode we want to install.  You need to add users who have access to manage the services, below I added the Administrator.  There is also a Data Directories tab.  You can change where the files, logs, temp directories are located.  I kept them the default, but you probably want to change them on a production instance.  To read more about the differences between the server modes, please follow the following link:




After clicking next, you get the summary screen and you are ready to install SSAS on your server.



In a couple minutes if all goes well, you will get the following success message.



If you check your services again, you will see that the SSAS services are now installed and running.



Now, what can you do with Analysis Services now that it is installed?  All kinds of cool stuff that we will see in future articles, but from Microsoft’s page:  “Analysis Services is an analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.”

Leave a Reply

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

You are commenting using your 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 )

Google+ photo

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

Connecting to %s