SQL Server 2017 multidimensional mode needed

sql sql-server sql-server-2017
Said Akbar picture Said Akbar · Jan 26, 2018 · Viewed 9.2k times · Source

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.

Answer

Said Akbar picture Said Akbar · Jan 27, 2018

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.

Related questions

Get unique values using STRING_AGG in SQL Server

The following query returns the results shown below: SELECT ProjectID, newID.value FROM [dbo].[Data] WITH(NOLOCK) CROSS APPLY STRING_SPLIT([bID],';') AS newID WHERE newID.value IN ('O95833', 'Q96NY7-2') Results: ProjectID value --------------------- 2 …

Read More
SQL Convert Milliseconds to Days, Hours, Minutes

I need convert a millisecond value, 85605304.3587 to a value like 0d 18h 21m. No idea on how to start that, is there something similar to a TimeSpan in SQL like there is in C#?

Read More
Produce DISTINCT values in STRING_AGG

I'm using the STRING_AGG function in SQL Server 2017. I'd like to create the same effect as COUNT(DISTINCT <column>). I tried STRING_AGG(DISTINCT <column>,',') but that is not legal syntax. I'd like …

Read More