Installing SQL Server 2012 Analysis Services–Tabular mode June 6th, 2013

Vinod Kumar

I wrote last week about DAX (Introduction to DAX in Excel) and we did mention there are many more blog posts on its way on that topic in future. I had a few requests from people on how to install SQL Server 2012 Analysis Services Tabular Mode. This is a picture blog post in a way showing the Step-By-Step process.

Q: The reason I wrote this is because a customer asked me with SQL Server 2012 Analysis Services already installed in their environment, how can they convert it into a tabular mode.

A: The matter of fact remains, we cannot convert the already installed multi-dimensional SSAS instance into tabular mode. We need to install a separate instance for this.

Installation Steps – Tabular mode

So if you have the SQL Server 2012 installation binaries ready, start the “setup.exe”. And go through the wizard as follows:

Select “New SQL Server stand-alone installation or add features to an existing installation” option.

Let the Setup Support Rules run and Click “OK”.

Ignore the Warning for “Windows Firewall” for now and press “Next”.

Select “Perform a new installation of SQL Server 2012”. Here is assumption is we already have an SSAS multi-dimension installation. If this is a fresh installation of SSAS, you can choose the second option.

If you have a valid Product Key, enter the same here or feel free to use an Evaluation version. Also go through the License Term and move next to “Setup Role”.

Under Setup Role, select “SQL Server Feature Installation”.

Select “Analysis Services” under the Feature Selection.

Press “Next” after checking the status in “Installation Rules”.

Under Instance Configuration, Give a “Named instance” – here we are calling it as POWERPIVOT. Our assumption is our default instance is the multi-dimensional SSAS instance. Press “Next”.

Check the Disk Space requirements and Server Configuration details and Click “Next”.

Under “Analysis Services Configuration” screen, select the “Tabular Mode”. This is the most important step. Also make sure to add the current user from the below button. Press “Next” to move ahead in installation.

Check the “Installation Configuration Rules” pass and you will be in “Ready to Install” screen as above. Please take a note of the “Configuration file path” and feel free to check the ConfigurationFile.ini if you want to use it in future for unattended installation. At this step, we are all set and ready to install. Click the “Install” button.

You will be presented with the final screen as above post install. This also has the Summary log file for installation. If any of your installation errors out, the details are present in this txt file mentioned.

This completes our installation of SQL Server 2012 Analysis Services Tabular Mode. In future blog posts we will write queries to this instance and show the functionality possible with this mode of installation.

Tags: , , , , , , , , ,

This entry was posted on Thursday, June 6th, 2013 at 08:00 and is filed under Technology. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply