importing Cubes from SQL 2008 R2 into SSAS 2016

  • datsun

    SSCrazy

    Points: 2238

    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

  • datsun

    SSCrazy

    Points: 2238

    ... and the server is Windows 2019

    Vinay

  • datsun

    SSCrazy

    Points: 2238

    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 3 (of 3 total)

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