Finding Your SSAS Installed Server Mode

You can read up on how to do this on MSDN here (https://msdn.microsoft.com/en-us/library/gg471594.aspx), but below is a quick summary.

The easiest option is to connect to SQL Server Management Studio and note the icon next to the server name in Object Explorer.










An alternative is the read the XML in the MSMDSRV.INI file searching for “DeploymentMode”.
                0 = multidimensional
                1 = PowerPivot for SharePoint
                2 = Tabular

---