Build Error: Elasticube build fail

Answered
Follow
Avatar
Alessio Santoro

I 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

~~

0

Comments

4 comments

Sort by Date Votes
  • Avatar
    Michael Becker

    Hi Alessio,

    ElastiCube service which is processing builds is setup to run as NT AUTHORITY\SYSTEM user, and you have to make that user at least a datareader on your MS SQL database. That will solve your issue.

    Regards,

    Michał

    0
    Comment actions Permalink
  • Avatar
    Alessio Santoro

    Thanks Michael.

    So I am using MS SQL 2012, and the database name is NORTHWND. What would the query be to add NT AUTHORITY\SYSTEM as a datareader?

    Thanks again

    0
    Comment actions Permalink
  • Avatar
    Michael Becker

    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ł

    0
    Comment actions Permalink
  • Avatar
    Malinda Jepsen

    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

    0
    Comment actions Permalink

Please sign in to leave a comment.

Didn't find what you were looking for?

New post