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'.
Jason
http://dbace.us
😛