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 |
|
SQLBoy14
Yak Posting Veteran
70 Posts |
 Posted - 2014-12-17 : 21:44:03
|
| Hi SQL expert,I have seen the issue logon failed for user NT Authority\Anonymous logon when running the SQL query. How to solve this error?Thank youSQLBoy |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-12-18 : 12:07:50
|
| This can on a linked server query where the target server is in an untrusted domain. Is that your situation? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-12-18 : 12:17:52
|
| If it's due to a linked server, you need to setup delegation: http://technet.microsoft.com/en-us/library/ms189580%28v=sql.105%29.aspxTara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
SQLBoy14
Yak Posting Veteran
70 Posts |
Posted - 2014-12-23 : 22:19:28
|
| Thank you gbritton and tkizer.SQLBoy |
|
|
|
|
|
|
NT Authority\Anonymous logon