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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Double hop linked server issue

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 Kereberos
The (SQL) service account of the "middle" server is trusted for delegation
All the machines have a correct SPN
I 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"
Go to Top of Page
   

- Advertisement -