Installation of SQL Server Analysis Service (SSAS) – SQL Server 2012


Ahamed Fazil Buhari
SharePoint Developer
Published On :   18 Nov 2016
Visit Count
Today :  1    Total :   1302
Plan, Migrate, Secure, Report
SharePoint & Office 365 Tool. Simple & Easy to Use. 15-Day Trial!

SharePoint Office 365 Tool
Simple & Powerful Tool for Migration, Security & Reporting. Free Trial


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,

clip_image002

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

clip_image004

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

clip_image006

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.

clip_image008

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.

clip_image010

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.

clip_image012

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.

clip_image014

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

clip_image016

10. Click next.

clip_image018

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

clip_image020

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

clip_image022

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.

clip_image024

Well, our SQL Analysis Service is up and running.

clip_image026

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

Ahamed

SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Categories

Migratiin Tools for SharePoint