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 |
cjvjr
Starting Member
7 Posts |
Posted - 2012-07-15 : 06:24:37
|
Hi,I hitnk a lot of you know about the double hop issues when working with linked servers.There are a lot op solutions that can be found. However, they don't provide the answer for me.Here is what i checked:All servers use KereberosThe (SQL) service account of the "middle" server is trusted for delegationAll the machines have a correct SPNI use used "klist" purge to purge the kerberos tickets on all servers.I stiil get the anonymous error when testing the linekd server.Any other suggestions?greetings,Kick |
|
aureolin
Starting Member
3 Posts |
Posted - 2012-07-17 : 19:04:31
|
My experience is that *both sides* of the linked server hop need to be trusted for delegation in addition to having proper SPN's________________________________________"It's more complicated than that" |
|
|
|
|
|