Aug 25, 2008 12:10 AM|bkr|LINK
Your error -> [..Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. ..]
is due to SQL Server not having the login account for your windows login account.
You must be getting this error when your sql server db is on remote machine. Also your app. server (IIS) has Impersonate = true.
If you make IIS not impersontate and then create a log in account in your db server , with
You won't get this error for some good reasons.
if you want your IIS server to impersonate , then this error will pop up on app. server machine, but remote client machine , it will all work out.