How to check or change the server mode of SSAS (SQL Server Multidimensional or Tabular)

Поделиться
HTML-код
  • Опубликовано: 13 сен 2024
  • You can only install one version of SSAS in your instance. But which version do you have?
    My SQL Server Udemy courses are:
    70-461, 70-761 Querying Microsoft SQL Server with T-SQL: rebrand.ly/que...
    98-364: Database Fundamentals (Microsoft SQL Server): rebrand.ly/dat...
    70-462 SQL Server Database Administration (DBA): rebrand.ly/sql...
    Microsoft SQL Server Reporting Services (SSRS): rebrand.ly/sql...
    SQL Server Integration Services (SSIS): rebrand.ly/sql...
    SQL Server Analysis Services (SSAS): rebrand.ly/sql...
    Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model): rebrand.ly/mic...
    ----
    There are two different versions of SSAS: Multidimensional (MDX) and Tabular. However, you can only have one of them installed at any one time. How can you check or change it?
    To check the version of SSAS, right-hand click on your Analysis Services node in SQL Server and go to Properties.
    To change the version, then you need to uninstall that component of SQL Server, and then reinstall the other component.
    ----
    Links to my website are:
    70-461, 70-761 Querying Microsoft SQL Server with T-SQL: idodata.com/que...
    98-364: Database Fundamentals (Microsoft SQL Server): idodata.com/dat...
    SQL Server Essential in an Hour: idodata.com/sql...
    70-462 SQL Server Database Administration (DBA): idodata.com/sql...
    DP-300: Administering Relational Databases: idodata.com/dp-...
    Microsoft SQL Server Reporting Services (SSRS): idodata.com/mic...
    SQL Server Integration Services (SSIS): idodata.com/sql...
    SQL Server Analysis Services (SSAS): idodata.com/sql...
    Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model): rebrand.ly/mic...
    1Z0-071 Oracle SQL Developer - certified associate: idodata.com/iz0...
    SQL for Microsoft Access: idodata.com/sql...
    DP-900: Microsoft Azure Data Fundamentals: idodata.com/dp-...

Комментарии • 5