SSAS change sql server 2017 from tabular to multidimnensional

P Fonteijn 1 Reputation point
2021-11-03T17:48:40.207+00:00

Need some help:

Tried to change my sql server instance from tabular to multidimensional and therefore I removed the 'analysis services' from the SQL server 2017 so I could reinstall the analysis services in multidimensional mode.
I was able to remove it but when I tried to reinstall with the installation wizard there was no checkbox for the 'analysis services' so I was unable to reinstall?

Thanks in advance!

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,244 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. CarrinWu-MSFT 6,851 Reputation points
    2021-11-04T03:38:32.133+00:00

    Hi @P Fonteijn ,

    Welcome to Microsoft Q&A!

    You don't need to remove SSAS, just change a value in msmdsrv.ini and then restart SSAS. For the detail steps, please refer to this thread.

    But now you already removed it, right? Based on my test, I removed all features of SQL Server 2017 and then reinstall it, it was successfully. Have you remove all SQL Server 2017 features?
    146329-installation.png
    146432-model.png
    146405-succeeded.png

    Best regards,
    Carrin

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments