Sisense's build failed when importing data
Answeredhi
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
-
@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ł
Please sign in to leave a comment.
Comments
4 comments