Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
geossl
Yak Posting Veteran
85 Posts |
 Posted - 2005-03-17 : 22:31:14
|
| Dear All, In the SQL Server log, there is a lot of "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON". What is this problem? Is there any way to figure out which machine is it? Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-18 : 13:35:30
|
| You can use SQL Profiler to see where these are coming from.Tara |
 |
|
|
TSQLMan
Posting Yak Master
160 Posts |
Posted - 2005-03-20 : 00:09:52
|
| Once you have found out where it is coming from you may want to Turn on Kerberos Logging on your SQL Server. MS KB Article# 326985. This could possibly be Kerberos failing, and falling back to NTLM in a double hop scenario. I am actually having that issue now. Thanks, TSQLMan |
|
|
|
|
|
|
Msg 'NT AUTHORITY\ANONYMOUS LOGON' in log