KNOWLEDGE BASE

Error: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'


Published: 29 Mar 2017
Last Modified Date: 18 Sep 2018

Issue

After upgrading the SQL driver to ODBC 13, Tableau Desktop may throw the following error:

[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'." on a live connection.

Environment

  • Tableau Desktop
  • Windows 10
  • MS SQL Server
  • ODBC Driver 13 for SQL Server

Resolution

Option 1
Work with your internal IT team to address the Kerberos delegation issue. Articles in Additional Information from Microsoft Support may be of assistance.

Option 2 
Uninstall the ODBC Driver 13 for SQL Server and install Native Client 11 for SQL Server:
  1. Go to Add/Remove Program.
  2. Remove Microsoft ODBC Driver 13 for SQL Server.
  3. Go to the Microsoft Download Center and download the Native Client 11 for SQL Server.
  4. Install ODBC Driver 11. 

Additional Information

As the Microsoft documentation describes, the Native Client and the ODBC Driver handle delegation slightly differently. This is why the issue commonly shows up after upgrading the SQL Server driver, and why rolling back the driver can resolve the issue. It's also important to note that when connecting to SQL Server using Windows Auth, if Kerberos doesn't work the connection fails over to using NTLM instead. However, any delegation or double-hop connection requires Kerberos.


Authentication methods for connections to SQL Server in Active Server Pages by Microsoft Support.
How to enable Kerberos event logging by Microsoft Support.

Note: The above blog post is hosted on a third-party website. Please note that while we make every effort to keep references to third-party content accurate and up to date, the information we provide here might change without notice.

Did this article resolve the issue?