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.

ss1

 

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.

ss0

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

ss2

 

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

ss3

 

Select Analysis Services as shown below.

ss4

 

Click next.

ss5

 

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:

https://docs.microsoft.com/en-us/sql/analysis-services/comparing-tabular-and-multidimensional-solutions-ssas

 

ss6

 

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

ss7

 

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

ss8

 

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

ss9

 

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.”

Advertisement

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 )

Facebook photo

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

Connecting to %s