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.
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.