jswong05 (7/27/2010)

---

Harold Buckner (12/11/2008)

---

Bradley Deem (12/11/2008)

I have the EXACT same problem with Kerberos. Resulting in the NT AUTHORITY\ANONYMOUS LOGON. It does work though, because I'm able to connect from a Web Server to the SQL server using Kerberos and from the Web Server to SSRS on another server. It just breaks like Harold described above. Log off/Log on to resolve.

I'm glad I'm not the only one.

Well written article. I followed the instruction. Set up SPN on where I can see correct SPN using SETSPN -L

My linkserver between the two hosts (SQL2005) using windows authentication (impersonation) is still getting same error:

Msg 18456, Level 14, State 1, Line 1

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.