when you try to create new tabular model or multidimensional model using SSDT. You may face this error:
"the workspace database server 'localhost' is not running in tabular mode" when you try to connect to local host analysis server.
to solve this error, make sure you already install analysis service + make sure to connect with correct workspace server, if its not 'localhost'. Final solution, try to connect with localhost\SqlServerInstanceName because analysis service takes default sql instance name in installation step.
"the workspace database server 'localhost' is not running in tabular mode" when you try to connect to local host analysis server.
to solve this error, make sure you already install analysis service + make sure to connect with correct workspace server, if its not 'localhost'. Final solution, try to connect with localhost\SqlServerInstanceName because analysis service takes default sql instance name in installation step.
Thank u Leslie
ReplyDeleteUnfortunately when you install Analysis Services you need to choose either the Multidimensional and Data Mining Mode or the Tabular Mode, you cannot have both on the same instance. Also, earlier versions of SQL Server do not support Tabular Mode this is new for SQL Server 2012
ReplyDelete