Tuesday, July 28, 2015

Installing SQL Server 2012 Analysis Services Tabular Mode


In this article, I will show you how to Install SQL Server 2012 Analysis Services(Tabular Mode).
1. First of all Run SQL Server 2012 Setup and go to Installation. Then click onNew SQL Server stand-alone installation or add features to an existing installation.
1-Installing SQL Server 2012 Analysis Services Tabular Mode
2. It will run Setup Support Rules.
2-Installing SQL Server 2012 Analysis Services Tabular Mode
Then click on OK button.
3. In next window click on Install button. It will again run Setup Support Rules.
3-Installing SQL Server 2012 Analysis Services Tabular Mode
If all rules run successfully, click on Next Button.
4. In next step, select Perform a new installation of SQL Server 2012 if you want to install new installation otherwise select Add features to and existing instance of SQL Server 2012.
Here we select 2nd option. Then click on Next button.
4-Installing SQL Server 2012 Analysis Services Tabular Mode
5. In next step, Select Analysis Services from Feature Selection. Then click on Next Button.
5-Installing SQL Server 2012 Analysis Services Tabular Mode
6. In next step, it will show you Disk usage Summary. Now click on Next Button.
6-Installing SQL Server 2012 Analysis Services Tabular Mode
7. In next step, select startup mode of SQL Server Analysis Services. Here we select Automatic mode. Then click on Next Button.
7-Installing SQL Server 2012 Analysis Services Tabular Mode
8. In next step, select Tabular Mode. Also specify users which have administrative permissions to access analysis services. Then click on OK button.
8-Installing SQL Server 2012 Analysis Services Tabular Mode
9. Now it will run Installation Configuration Rules.
9-Installing SQL Server 2012 Analysis Services Tabular Mode
Then click on Next Button.
10. Now all ready to Install Analysis Services .Click on Install Button.
10-Installing SQL Server 2012 Analysis Services Tabular Mode
11. After completion of installation, you will see screen like below.
11-Installing SQL Server 2012 Analysis Services Tabular Mode
Congratulations! We successfully completed installation of Analysis Services.