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”.
SQL ensure all the required supporting files, once it validates it will show status as passed.
Once the validation of the supporting file completes SQL check for all the required updates.
As part of SSAS installation SQL validates all the support rules.
Click on “Add features to an existing instance SQL Server 2012” option and click on Next.
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.
SQL validates the Installation rules as shown below.
As soon as SQL validates the Installation rules it will perform check for the required space.
Click on Account Name dropdown to add SQL Server account and enter a password for the same service account then click on Next.
Add all the services which you need full / admin access on SSAS service then click on Next.
Click on checkbox as highlighted in below screenshot to send the error messages to Microsoft and click on Next.
In this step, SQL validates/run the Installation Configuration rules to ensure seamless SSAS setup.
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.
Once the installation gets completed, SQL will show the success message as below.
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.
As shown below our installation is successful and we can Analysis Server instance.
You may like following SQL Server tutorials:
- Importing SQL Server Analysis Services (SSAS) Sample CUBE and Processing the CUBEs
- SQL Server Reporting Services installation and configuration in SharePoint 2016/2013
- Killing a SPID in SQL Server and Checking Rollback Progress
- Create SharePoint site programmatically
- SharePoint content database tutorial
- SharePoint user custom actions (Designer + Programmatically)
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.
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