Error "[SQL Server]Login failed for user 'domain\username$'" Refreshing Extract
Published: 04 Aug 2015 Last Modified Date: 03 Jun 2016
When refreshing an extract in Tableau Server, the following error might occur:
[Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'domain\username$'. Invalid username or password.
MS SQL Server
Change the Run As user account to a domain account that as access to the SQL Server database.
Change the data connection so that it uses SQL authentication and embedded password.
The authentication option chosen for the affected connection is using the Tableau Server Run As user account. However, the Run As user is a local machine account and does not have access to the SQL Server database.
Usernames ending in a dollar sign ($) are managed service accounts and an indicator the NT AUTHORITY\NetworkService account is being used as the Run As user account.
Thank you for providing your feedback on the effectiveness of the article.