Server Modes of an Analysis Services Instance

Analysis Services can be installed in one of three server modes:

• Multidimensional and Data Mining (default)
• PowerPivot for SharePoint
• Tabular. 

The easiest way to determine the server mode of Analysis Services instance of SQL Server 2012 is to connect to the server in SQL Server Management Studio and note the icon next to the server name in Object Explorer.

The server mode of an Analysis Services instance is determined during setup when you choose options for installing the server.