Sisense's build failed when importing data

Answered

Comments

4 comments

  • Avatar
    Michael Becker

    @Yaron - When you add tables to ElastiCube Manager you specify an user which logs in to SQL database. But when build is executed it uses user on which ElastiCubeManagement service runs - in your case NT AUTHORITY\SYSTEM. There are two ways to deal with that:

    1. Change account on which EaltiCubeManagement service runs to one which has proper access to SQL

    2. Add NT AUTHORITY\SYSTEM with Data Reader role to Northwind database.

     

    Hope it helps.

    Regards,

    Michał

  • Avatar
    yaron schwarzman

    hi Michael

    Thanks for your help :)

    I've added the NT AUTHORITY\SYSTEM user with Data Reader role to Northwind database and ran the build.

    The build ended successfully.

    thanks

    Yaron

  • Avatar
    Oxana Noa Umansky

    Hi Yaron,

    Thank you for your post. I moved your post to the Elasticube Manager forum where posts on similar topics are being published. 

    Thanks,

    Oxana

  • Avatar
    Expand Dev

    Hi Michael,

    I tried changing the account the ElasticubeManagementService runs on, but when you do this the elasticube manager cannot connect to local anymore.

     

    Thanks, James

Please sign in to leave a comment.