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

sql server analysis services download

Objective:
In this article step by step, we will learn how to configure SQL Server Analysis Services (SSAS) in SQL server 2012.

Why should I need to learn this?

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.

1. Log on to SQL Server where you want to configure SSAS
2. Launch SQL Server setup
3. Click on “New SQL Server stand-alone installation or add features to an existing installation”

sql server express analysis services
sql server express analysis services

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



sql server express analysis services tutorial
sql server express analysis services tutorial

5. Once the supporting files validation completes SQL check for all the required updates.

sql server express analysis services configuration
sql server express analysis services configuration

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

how to configure sql server express analysis services
how to configure sql server express analysis services

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

configure SSAS in SQL Server 2012
configure SSAS in SQL Server 2012

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

how to configure ssas in sql server 2012
how to configure ssas in sql server 2012

9. SQL validates the Installation rules as shown below

sql server analysis services download
sql server analysis services download

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



sql server analysis services 2016
sql server analysis services 2016

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

sql server analysis services 2016 steps
sql server analysis services 2016 steps

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

sql server analysis services 2016 tutorial
sql server analysis services 2016 tutorial

13. Click on check box as highlighted in below screen shot to send the error messages to Microsoft and click on Next.

sql server analysis services 2016 download
sql server analysis services 2016 download

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

sql server analysis services 2012
sql server analysis services 2012

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

sql server analysis services 2012 download
sql server analysis services 2012 download

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

sql server analysis services 2012 tutorial
sql server analysis services 2012 tutorial

17. 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 2012 install
sql server analysis services 2012 install

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

how to install analysis services in sql server 2016
how to install analysis services in sql server 2016

Hope this helps, in the next article I will walk you through the process of importing sample DB and CUBE.
Happy development in Microsoft world !!!!


You May Also like the Following SharePoint Online Tutorials:

About Krishna Vandanapu

I am Krishna.Vandanapu a SharePoint architect working in IT from last 12 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 →