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)

  • July 16, 2007 at 5:02 am

    #719625

    Change the network service account to a domain account in both the servers. This is because of hop issue.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com