While I was migrating my database server from SQL 2000 to SQL Server 2005 I came across this error
complete post here: http://dotnetolympians.wordpress.com/2008/07/22/login-failed-error-msg-18456-sql-server-2005-login-failed-for-user-nt-authorityanonymous-logon/
Best Regards,
Muhammad Arsalan Ayub
User Group Leader DotNetOlympians
http://mvp.microsoft.com/profile/Arsalan
http://dotnetolympians.wordpress.com