Loading

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

Publiseringsdato: Mar 25, 2025
Beskrivelse

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.

Cause

The "NT AUTHORITY\ANONYMOUS LOGON" error message indicates a Kerberos delegation error. The article, Authentication methods for connections to SQL Server in Active Server Pages, from Microsoft Support has more details about the issue.

Løsning

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. 
Flere ressurser

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 links are 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.
 

 

Knowledge-artikkelnummer

001473408

 
Laster
Salesforce Help | Article