tag:blogger.com,1999:blog-2173119910600284569.post2034554413619880926..comments2024-02-06T04:58:09.639-05:00Comments on Kendal Van Dyke: Delegation: What It Is And How To Set It UpUnknownnoreply@blogger.comBlogger2125tag:blogger.com,1999:blog-2173119910600284569.post-50988700801036210162008-11-21T09:48:00.000-05:002008-11-21T09:48:00.000-05:00If SQL on servers A, B, and C is running under a d...If SQL on servers A, B, and C is running under a domain account, then yes you would need to set up delegation.<BR/><BR/>If you haven't seen it, read my follow up post on Service Principal Names. I link to a utility which will let you query AD to find out which servers have a SPN set up. It sounds like one of your servers doesn't have a SPN.Adminhttps://www.blogger.com/profile/10237600176486018239noreply@blogger.comtag:blogger.com,1999:blog-2173119910600284569.post-19484568446025263222008-11-21T02:44:00.000-05:002008-11-21T02:44:00.000-05:00I have a question here... If the 3 servers A,B,C a...I have a question here... <BR/>If the 3 servers A,B,C are in same domain, Same OU then is it needed to setup delegation?<BR/><BR/>Why I'm asking this is<BR/>Case 1:<BR/>I connect to Server A which is CA(USA) and I'm able to query a linked server table from this server to server B which is in NY(USA).<BR/><BR/>Case 2:<BR/>I connect to Server A which is CA and I'm NOT able to query a linked server table from this server to server B which is in Korea.Sakthihttps://www.blogger.com/profile/11254378667387652586noreply@blogger.com