K. Brian Kelley (11/16/2011)
Kerberos authentication was likely set up. Was Kerberos delegation configured? This is required to go through the linked server connection to another SQL Server using the passed Windows credentials. If not, this whitepaper discusses how to do so for the linked server scenario.How to Implement Kerberos Constrained Delegation with SQL Server 2008
Sorted! Thanks a Mil Brian! It was all about the delegation! Funny, ive been googling this issue for a few hours and not once did delegation come up as the cause of the issue. most peole just settled for sql authentication and left it at that.
Thanks again Brian!