Configure SQL Server Analysis Services (SSAS) in SQL Server 2012 Step by step guide

sql server analysis services download
SharePoint deveopment training course

This SQL Server tutorial explains we will learn how to configure SQL Server Analysis Services (SSAS) in SQL server 2012.

Being SharePoint guy we need to learn SSAS because SSAS play a major role in SharePoint 2013 BI. SSAS is a prerequisite for:

  • SharePoint PowerPivot
  • SharePoint View

We will certainly learn how to configure these 2 in my future articles. Follow the below steps to configure SSAS.

What is SQL server analysis services(SSAS)?

Microsoft SQL Server Analysis Services (SSAS), is an online analytical and transactional processing (OLAP) and data mining tool in Microsoft SQL Server. SSAS is used as a tool by organizations to analyze and make sense of information possibly spread out across multiple databases, or in disparate tables or files.

Configure SQL server analysis services

Log on to SQL Server where you want to configure SSAS

Launch SQL Server setup

Click on “New SQL Server stand-alone installation or add features to an existing installation”.

configure sql server analysis services

SQL ensure all the required supporting files, once it validates it will show status as passed.

configure sql server analysis services 2012

Once the validation of the supporting file completes SQL check for all the required updates.

setup sql server analysis services

As part of SSAS installation SQL validates all the support rules.

setting up sql server analysis services

Click on “Add features to an existing instance SQL Server 2012” option and click on Next.

configuring permissions for sql server analysis services

Now SQL will redirect you to select the features to be installed. Select

  • Analysis Services
  • SQL Server Data Tools
  • Ensure that Management Tools at the end of the features list

Once you ensure/perform the above steps click on Next.

configure analysis services sql server 2016

SQL validates the Installation rules as shown below.

analysis services configuration sql server 2017

As soon as SQL validates the Installation rules it will perform check for the required space.

sql server 2016 analysis services configuration server mode

Click on Account Name dropdown to add SQL Server account and enter a password for the same service account then click on Next.

sql server 2014 analysis services configuration server mode

Add all the services which you need full / admin access on SSAS service then click on Next.

analysis services configuration sql server 2017

Click on checkbox as highlighted in below screenshot to send the error messages to Microsoft and click on Next.

analysis services configuration sql server 2016

In this step, SQL validates/run the Installation Configuration rules to ensure seamless SSAS setup.

analysis services configuration sql server

Once all the prerequisite validations are completed you will see the below screen to install the SSAS. Before you click on Install button ensure that all the required features are selected as mentioned below.

configure analysis services sql server 2012

Once the installation gets completed, SQL will show the success message as below.

sql server analysis services configuration server mode

Now that the installation is completed, let us quickly check the instance in Management studio by as shown below:

  • Select server type as “Analysis Services”
  • Server name: << Select your server name>> in my case it is “sharepoint13\mstechsql12”
  • Select the proper admin account get connect to Analysis Server.
sql server analysis services configuration best practices

As shown below our installation is successful and we can Analysis Server instance.

how to configure SQL server analysis services (SSAS) in SQL Server

You may like following SQL Server tutorials:

Hope this helps, in the next article I will walk you through the process of importing sample DB and CUBE. This tutorial explains, how to configure SQL server analysis services (SSAS) in SQL Server.

Check out Best Alternative to InfoPath -> Try Now

free sharepoint training

SharePoint Online FREE Training

JOIN a FREE SharePoint Video Course (3 Part Video Series)

envelope
envelope

About Krishna Vandanapu

I am Krishna.Vandanapu a SharePoint architect working in IT from last 13+ years, I worked in SharePoint 2007, 2010, 2013, 2016 and Office 365. I have extensive hands on experience in customizing SharePoint sites from end to end. Expertise in SharePoint migration tools like Sharegate, Doc Ave and Metalogix. Migrated SharePoint sites from SharePoint 2007 to 2010 and 2010 to 2013 several times seamlessly. Implementing CSOM with Microsoft best practices. Spent quality time in configuring SharePoint application services like User Profile, Search, Managed Meta data services etc. Now exploring SharePoint Framework and SharePoint 2019

View all posts by Krishna Vandanapu →