Yes its a Link Server where am querying from.

So for the above version i have do i need to install this below

What do u mean by SP3 is out? do u mean its not necessary.

pls check back my post i have edited with error mesg.

I can connect to all the servers from SSMS with my domain account.

and when i run this query i get KERBEROS for my login but for other logins and the...

Brain

I am not sure what you are asking, sorry abt it.

I can connect to all servers by RDP'ing but when i RDP into serverA and connect to ServerB and pull...

Yes all are in the same domain.

For delegation i checked with this query

select uses_self_credential as delegation

from sys.linked_logins as L, sys.servers as S

where S.server_id=L.server_id and S.name=N'LinkSErver'

Yes i did setup spn with setspn utility from cmdline.

I checked delegation on all 3 servers it returns "1" to me that means it is active.

When checked all the login sessions i see that they still use NTLM except...

Guys.. its driving nuts for me, though i setup authentication to KERBEROS still i cant run query from from servrB to servrC when logged into servrA

Here is my setup

Logged in...

The weired thing is same process runs gud on a different database.

How can i use Impersonate login when am not using windows authentication. I have a sql login which links all the servers and i gave read and write access to...

Here is the original view where above query is looking into

ALTER VIEW [dbo].[Revenue]

AS

SELECT * FROM Reval204

where RevCode = 'I'

and (Rev_ID is null or Rev_ID='PET')

UNION ALL

SELECT * FROM Reval205

where...

I am trying to configure this for my Link Server as given in this article.

http://kendalvandyke.blogspot.com/2008/11/delegation-what-it-is-and-how-to-set-it.html

but i have a doubt, do i need to configure this for SQL server account or...

The weired thing is it is just hanging at one table 5 tables before that in a job went well and at only 1 table it got stucked.