question

PFonteijn-3965 avatar image
0 Votes"
PFonteijn-3965 asked CarrinWu-MSFT commented

SSAS change sql server 2017 from tabular to multidimnensional

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
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @PFonteijn-3965, we have not get a reply from you. Could below answer help you? If yes, please do "Accept Answer". By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!

0 Votes 0 ·

1 Answer

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered

Hi @PFonteijn-3965,

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.



installation.png (70.8 KiB)
model.png (28.0 KiB)
succeeded.png (45.2 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.