Sisense's build failed when importing data

Answered

Follow

yaron schwarzman

November 05, 2016 14:56

hi

 

I'm trying to run a build for he Northwind's data base tables.This DB is a connected through Microsoft SQL server connection.

I'm getting the following error when running the build:

Import failed. cannot open database "northwind" requested by the login. The login failed.Login failed for user 'NT AUTHORITY\SYSTEM'.

Do you know if I need to change anything in my definitions?

thanks

Yaron 

0

• 

  Michael Becker November 05, 2016 18:00

  @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ł

  0

  Comment actions Permalink
• 

  yaron schwarzman November 05, 2016 19:37

  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

  0

  Comment actions Permalink
• 

  Oxana Noa Umansky November 14, 2016 14:05

  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

  0

  Comment actions Permalink
• 

  Expand Dev July 03, 2018 16:08

  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

  0

  Comment actions Permalink

Please sign in to leave a comment.