Do you have the linked server connections setup to "be made using the login's current security context"? If you do you likely are experiencing a double-hop authentication issue and you need to properly get Kerberos setup on both the SQL Servers. K. Brian Kelley has a good article on this site for Setting up Kerberos that can be found here.[/url]
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question