SQL Server 2017 multidimensional mode needed

Question

MS SQL Server 2017 (developer edition) is connected and running on my PC. However, when I want to start the develop process in MS Visual studio 2017, it is giving me the following error:

You cannot deploy the model because the localhost deployment server is not running in multidimensional mode.

I tried reinstalling MS SQL server with additional features, but I cannot find this multidimensional option. I googled some articles and they solved it in older versions of MS VS, however, they are not helpful in MS VS 2017. Please, give some suggestions.

Nausea

Can you give more detail on what is this "develop" process you are trying to start is? – Gerhardt

I am trying to build an OLAP cube. – Nausea

any ideas? @BradleyUffner – Nausea

That mode is selected at installation time of the instance and can't be changed as far as I know. You will need to reinstall analysis services with that option, or add a new instance with it selected. – Gerhardt

see also: https://mcmap.net/q/848292/-changing-sql-server-db-from-tabular-to-multidimensional/1747983 – Bioecology

If one has more than one local instance then the default will be chosen. One can Right click the project and correct the instance to the correct one. My default instance does not have multidimensional so I changed the connection string and this solved this issue. – Substratum

Answer 1

Well, it turns out I did not need to re-install the instance. Instead, I had to change msmdsrv.ini in C:\Program Files\Microsoft SQL Server\MSAS14.MSSQLSERVER\OLAP\Config. The line <DeploymentMode>2</DeploymentMode> in the file (2 means tabular) should be changed to <DeploymentMode>0</DeploymentMode>. After restarting the analysis server, I finally managed to run the server in multidimensional mode.

Nausea

Nice one bro. Just a word to the wise: close your SQL manager first and open this ini file in admin mode. – Amalekite

Microsoft suggests not to change DeploymentMode manually. The better solution would be to reinstall Analysis services and choosing Multidimensional mode during the installation. Source: learn.microsoft.com/en-us/analysis-services/instances/… – Raby