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)

  • If you use full-text searching, you must grant the NT Authority\System sysadmin rights to SQL Server if the Builtin/Administrators role is removed:

    EXEC sp_grantlogin [NT Authority\System]

    EXEC sp_addsrvrolemember @loginame = [NT Authority\System], @rolename =  'sysadmin'

    See http://support.microsoft.com/?id=263712 for the full article.