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

Published: 29 Mar 2017
Last Modified Date: 30 Jul 2020


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.


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


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 SQL Native Client:
  1. Go to Add/Remove Programs.
  2. Remove Microsoft ODBC Driver 13 for SQL Server.
  3. Download the SQL Native Client for SQL Server.
  4. Install the Native Client Driver; sqlncli.msi

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.

Discuss this article... Feedback Forum
Did this article resolve the issue?