Installing SQL Server 2012 SSAS Tabular Mode

In this post we will cover the step-by-step process to install SQL Server 2012 Analysis Services in Tabular Mode.  This post assumes that you have already gone through the process of installing a SQL Server 2012 Analysis Services multi-dimensional instance.

One common question that comes up is, “can I convert my existing SSAS multidimensional instance to a tabular instance?”.  The answer is that you cannot convert an already installed SSAS multidimensional instance to tabular.  It requires a separate install and instance for this.  Also, important to note tabular mode is required if you want to access the tabular model over the network.

The following steps provided will walk you through the installation wizard to install a SSAS tabular instance.

Tabular Instance Installation

If you have the SQL Server 2012 binaries available, start/click the “setup.exe”.  The SQL Server Installation setup wizard will launch.
Tab0_Snag

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

Tab1_Snag

Allow the Setup Support Rules to run and then click OK.

Tab2_Snag

In the Setup Support Rules, ignore the Windows Firewall warning (for now) and click Next.

Tab3_Snag

Select the “Perform new installation of SQL Server 2012” option. Again the assumption is that we have already performed an installation of a SSAS multidimensional instance.

Tab4_Snag

If you have a valid product key, you will enter it here.  You can also use an Evaluation copy that will be good for 180 days.  After you complete the option that applies to your situation click Next.

Tab5_Snag

Go through the Setup Role step.  Select the SQL Server Feature Installation option.  Then select Next.

Tab7_Snag

Select Analysis Services in the Feature Selection step.

Tab8_Snag

After reviewing the Installation Rules Status (all should have a status of passed), select Next.

Tab9_Snag

In the Instance Configuration step, a named instance is established.   The named instance in this case is Tabular.  Again, the assumption is that there has already been a multidimensional instance previously installed.  Enter the name into the Named Instance field.  Note you may have to check the Default Instance radio button to enter the same value that is entered in the Named Instance field in the Instance Id field.

Tab10_Snag

Check the Disk Space requirements.  Then select Next.

Tab11_Snag

Check the Server Configuration details.  Then select Next.

Tab12_Snag

This is the most important step in the installation process.  In the Analysis Services Configuration screen, select Tabular Mode.   Also, be sure to select the Add Current User button.  Then select Next.

Tab13_Snag

Perform the Installation Configuration step.  All items should have a Passed status.  Then select Next.

Tab14_Snag

Now you are ready to perform the install.  Take note of the Configuration file path.  The ConfigurationFile.ini can be leveraged in the future to perform an unattended installation.  Once your review is complete, select Install.

Tab15_Snag

Installation Progress

Tab16_Snag

You will be presented with a final screen indicating the outcome of the installation.  In my case, I had previously applied Service Pack 2 before installing the Tabular instance.  This required that I re-install Service Pack 2 so that it would apply to the Tabular instance as well.  I cover this in the following post.

1 Trackback / Pingback

  1. SSAS Tabular vs. SSAS Multidimensional – Which One Do I Choose? – Part I | FalconTek Solutions Central

Leave a Reply

Your email address will not be published.


*


This site uses Akismet to reduce spam. Learn how your comment data is processed.