Issues with multiple SSAS tabular instances on same server

  • I have created a second instance of a tabular server on the same server but I am having issues processing the data using "process full" from SSMS. I can turn on both instances at the same time, however the first instance that gets turned on is the only one that can be processed. The second instance wont process and returns the error "Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: We're sorry, an error occurred during evaluation..'.". If I turn off the first instanced turned on, the second one will then work. When connecting to the 2 instances, I am explicitly setting and referencing the port numbers. How can I get around this?

    Another gotcha on it is that I can do a "process default" or "process clear" on the second turned on instance, I just cant process any sort of data.

    Thank you,

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply