• Home
  • Modeling for BI
  • DBA
  • Azure
  • SSIS
  • SSAS
  • SSRS - Reporting
  • PBI - Analytics
  • Consulting
  • About
Microsoft Data & AI

SQL Server Analysis Services

Finding Your SSAS Installed Server Mode

5/24/2015

0 Comments

 
Picture
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

Picture
0 Comments

    Categories

    All
    Cache
    DBA
    Excel
    Extended Events
    HOLAP
    MOLAP
    Multidimensional
    ROLAP
    Server Mode
    SSAS
    Tabular

    RSS Feed

    Tweets by @SqlServerSME
Powered by Create your own unique website with customizable templates.
  • Home
  • Modeling for BI
  • DBA
  • Azure
  • SSIS
  • SSAS
  • SSRS - Reporting
  • PBI - Analytics
  • Consulting
  • About