Home Forums SQL Server 7,2000 SQL Server Agent Login failed for user ''NT AUTHORITY\ANONYMOUS LOGON''. [SQLSTATE 28000] (Error 18456) RE: Login failed for user ''NT AUTHORITY\ANONYMOUS LOGON''. [SQLSTATE 28000] (Error 18456)

  • just had this happen to me

    i'm setting up backup monitoring like in the article from a few weeks ago. not using a powershell script because i have some old clients. just setting up SQL jobs with the raw code. tried the code on my laptop and got the error. RDP'd into a server and tried it from there and it worked.

    looked it up and it's the double kerberos jump like someone said earlier in the thread.