I have following problem: When I try to deploy my SSAS project (with cube, dimensions and all that jazz) to sql-server, it throws error saying that
You cannot deploy the model because the DB deployment server is not running in multidimensional mode.
I'm new to this, so it might be a dumb question, but how do I change database mode from tabular to multidimensional?
Tabular and Multi Dimensional are completely different thing. When you install SQL Server, you have to choose which one you are going to install.
So, if you create a Tabular model, you only can deploy it to Tabular installation of SSAS and the same for Multi Dimensional
you can not convert those model to each other.