KNOWLEDGE BASE

SQL Extract Refresh Fails with "Login failed for user" Error


Published: 17 May 2013
Last Modified Date: 22 Jul 2016

Issue

When working with extracts on Tableau Server, you may notice that workbooks that are connected to Microsoft SQL Server data sources do not refresh or you see the following error message in the Background Tasks admin view:
 
SQL Server database error 0x80040E4D: Login failed for user <username>

Note: <username> in the error is different from the user who published workbook. 
 

Environment

  • Tableau Server
  • Windows NT authentication
  • Microsoft SQL Server data source

Resolution

To resolve this issue, try one of the following two options: 
  • Option 1: Allow the Tableau Server Run As User account permissions to access the SQL Server database.
  • Option 2: Alternatively, you can edit the SQL Server connection and specify the credentials manually using Tableau Desktop. Then during publish, you can choose embed the database credentials. 

Cause

When using Windows NT authentication, it is not possible to embed database credentials because Tableau Desktop does not receive the actual username or password of the person who publishes the workbook. Instead, Windows provides a temporary authentication token that cannot be saved by Tableau Server.  
Did this article resolve the issue?