0

I am an administrator in SSAS.

I have many data warehouse servers.

In some servers I have SQL Server and SSAS on the same machine.

I successfully backup the SSAS databases and even check if the backups are healthy

Recently, however, one of our servers which is managed by a third party company based in Canada, needed to be replaced, and while migrating all the ssas databases from the old server to the new one

this is the old server: enter image description here

this is the new server: enter image description here

I am getting this error message while processing the database in the new server:

This command cannot be executed on database 'DWCA' because it has been defined with StorageEngineUsed set to TabularMetadata. For databases in this mode, you must use Tabular APIs to administer the database.

enter image description here

  • Is your SSMS version also same between the 2 Servers ? Have you tried with the exact same version of SSMS in the new server ? – Subbu Sep 22 '19 at 6:50
  • What compatibility level is the actual DB on each server? (Your screenshot only shows the max level the server can run, not the models themselves) I recall getting the same error when we upgraded our models from 1103 to 1200. (MS's move from ASSL to TMSL) – Brandon McClure Nov 22 '19 at 23:46
2

It sounds like you are trying to process your tabular model (which is of version >= 1200) with XMLA script (so all in all command is in XML). That kind of tabular model has to be processed with JSON command. I had the same error message and it just turned out that I was trying to refresh the newer tabular model (of version >=1200) with XMLA command. After using JSON command - it all worked. Probably for some reason while moving the tabular model from one server to another - the version of that tabular model was somehow upgraded to >= 1200. Or you are using old SSMS which is only capable of producing XMLA commands.

| improve this answer | |
0

enter link description hereAfter some time I manage to find a solution for this. Unfortunately, there are no ways (at least that I could find) to change SSAS, that worked in all environments.

I did this: How to uninstall SSAS

Changing an Analysis Services instance to tabular mode

It worked in some servers but not on other server. Also:

Be Careful ! SSAS Analysis services cannot be uninstalled from a SQL cluster once installed

Therefore my solution was to change SSAS when not possible to remove SSAS. what I was really wanted to achieve was to get the tabular mode installed with default instance name.

get to this: enter image description here

More information is here:

Install SQL Server Analysis Services

and specially this link:

Determine the Server Mode of an Analysis Services Instance

After that you can check Tabular In-Memory mode, which is very interesting.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.