June 18, 2019 at 5:13 pm
Hello,
I am trying to move off OLAP/SSAS cubes from SQL 2008 R2 into SQL 2016.
My first hurdle is to make some sense out of these errors. Any clues/thoughts are appreciated.
The impersonation mode is set to "use the credentials of the current user."
From the "SQL Server Configuration Manager", I have set SSAS service to log on as Network Service and restarted the service too.
Errors and Warnings from Response
Internal error: The operation terminated unsuccessfully.
Errors in the high-level relational engine. The database operation was cancelled because of an earlier failure.
The datasource, '<NAMEOFTHESOURCE>', contains an ImpersonationMode that is not supported for processing operations.
Is there anything I need to do on SSAS 2016 to make the Processing... work?
Many thanks
Vinay
June 18, 2019 at 5:15 pm
... and the server is Windows 2019
Vinay
June 19, 2019 at 3:24 pm
Hello
It's worked somehow.
I processed each Dimension separately, after I changed the Impersonation Info to "domain\username: password".
And then processed the Cube itself.
Why would it not work under " use the credentials of current user"? or "service account" or "inherit"?
The SQL 2008 SSAS happily works under service account, but not SQL 2016.
Thank you,
Vinay
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply