Build Error: Elasticube build fail
AnsweredI imported data from MSSQL database, but cannot successfully build the elasticube. Not sure what I need to do here. Please see screenshot below.
"Cannot open database "NORTHWIND" requested by the login. The login failed. Login failed for user 'NT AUTHORITY\SYSTEM"
Thanks!
Edited by Moderator
~~
-
Hi Alession,
once you login to your MS SQL data base with SQL Management Studio, got to Security branch, and then right click on NT AUTHORITY\SYSTEM there and go to Properties. New window will open, go to User Mappings, you will see a list of all available data bases on your server, select NORTHWIND, and below the list check datareader role. Click on Save button and that should do it. Hope it helps.
Regards,
Michał
-
Another alternative is to create a service account that you can use to talk to your SQL Server. This is usually seen as a best practice in MS SQL. Create an account such as <domainname>\SVC-Sisense or something similar (whatever your naming convention is). Stop each Sisense service and change them to use this login and it will prompt you to tell you that it is giving the account permissions to login as a service. Then you can make that user a datareader in your source system. That way you aren't giving a system account access to your SQL Server.
Malinda
Please sign in to leave a comment.
Comments
4 comments