SharePoint Pals
 | Sign In
Installation of SQL Server Analysis Service (SSAS) – SQL Server 2012
by Ahamed Fazil Buhari 18 Nov 2016
SharePoint Developer
Today  :   3     Total  :    372

In this article, we’ll look into the step by step approach to install SQL Server Analysis. To take full advantage of the Business Intelligence options of SharePoint 2013, we need to have SQL Server Analysis Services running on our SQL Server.

We’ve installed this on our existing SQL Server as an added feature. It doesn’t make much difference if you go ahead with New SQL Server stand-alone installation. Ok, let go step by step on installation process.

1. Open your SQL Server 2012 setup file and it will open up the below window,


2. It will do the Rule Check. In this case everything is passed. Click OK.


3. Now, it will go ahead and check for updates and click on next to install that updates.


4. After installing the updates, it will again do the Rule Check as shown below. Everything is passed except Windows Firewall which is in warning status. Anyway we will deal with this windows firewall configuration in another article. As of now, let’s go and click on next.


5. As I said earlier, we are adding feature to an existing instance of SQL Server 2012 and select the server name in the dropdown and click on next.


6. This is an important step, in this step we need to choose the Features that we want to install. We need Analysis Services, SQL Server Data Tools and Management Tool – Basic.


7. Click on next in Installation Rules and Disk Space Requirements.

8. In Server Configuration step, provide the account for the SQL Server Analysis Services (Microsoft recommends that you use a separate account for each SQL Server service.) and click on next.


9. In Analysis Service Configuration, select the mode. We want to make sure that Multidimensional and Data Mining Mode should be selected. Also we need to specify which user have administrative permission for the Analysis Services. So I clicked on Add Current User


10. Click next.


11. Click on Install and it will take few minutes to install all the components.


12. Everything is completed and successful, so simply click on close.


Go to SQL Server Management Studio to check the connectivity of our Analysis Services. Select the Server type as: Analysis Services and provide the Server name and give authentication details.


Well, our SQL Analysis Service is up and running.


Currently there are no Databases inside it, in my next article I will explain on ‘How to Attach Database and Give Access to SSAS Service Account in SQL Server 2012’.

Happy Coding


blog comments powered by Disqus

SharePoint Pals

SharePoint Pals, a community portal for SharePoint developers, Administrators and End Users. Let's join hands and share the point together.
Read this on mobile


Angular Js Training In Chennai
Advanced Angular Js training with real world developer scenarios
Angular Js, Web Api and Ionic for .Net Developers
All in one client side application development for .Net developers
Angular Js For SharePoint Developers
Get ready for the future. Its no more just C#

Get Connected

SharePoint Resources

SharePoint 2013 and 2010 Web Parts
Free Web Parts with Source Code for SharePoint Community

SharePoint 2013 Books and Tutorials
Collection of free SharePoint 2013 books and tutorials (eBooks, pdfs)

Supported By

Contribute your article and be eligible for a one month Free Subscription for Plural Sight. The Author of the most popular New Article (published in the previous month) will be awarded with a Free One month Plural Sight Subscription. Article can be sent to in a word document.

Related Resources

Recent Tweets

Twitter November 21, 21:08
Implementing Multi-Threading with MaxDegreeOfParallelism in SharePoint using CSOM – An Insight -

Twitter November 21, 12:48
Configure Windows Firewall for SQL Server Analysis Service (SSAS) -

Twitter November 21, 12:46
Implementing Multi-Threading in SharePoint To Upload Files using CSOM C# – An Insight -

Twitter November 20, 21:48
How to Get the Client Context Using App Access token, by passing Client ID using CSOM in SharePoint Office 365 -

Twitter November 18, 21:30
How to Enable Auto Approval For Permission Requests in Community Site Template – Office 2013 using Client Side Object Model (CSOM) C#

Follow us @SharePointPals
Note: For Customization and Configuration, CheckOutRecent Tweets Documentation