Post reply

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

  • September 9, 2015 at 8:51 am

    #399010

    Hello Experts,

    Many a times see the below error in SQL Error log.

    Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: ]

    Is this something to do here?

    Note: If I run the below statement I know that the SQL Error log entry will go off, but wanted to know the real significance of this error?

    CREATE LOGIN [NT AUTHORITY\ANONYMOUS LOGON] FROM WINDOWS

    Thanks

    Thanks.

  • September 10, 2015 at 12:36 am

    #1825595

    SQL-DBA-01 (9/9/2015)

    Hello Experts,

    Many a times see the below error in SQL Error log.

    Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: ]

    Is this something to do here?

    First guess on how this happens would be a second hop in a connection chain without Kerberos, i.e.

    😎 --(1st.)-->[Srv#1]--(2nd.)-->[Srv#2]

    Note: If I run the below statement I know that the SQL Error log entry will go off, but wanted to know the real significance of this error?

    CREATE LOGIN [NT AUTHORITY\ANONYMOUS LOGON] FROM WINDOWS

    Not certain what you're trying to achieve with this, why create anonymous login? Try rather to trace the origin of the login.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply