As Gus said, it is a double-hop or multiple-hop issue which means you need to use Kerberos delegation in order to use trusted authentication with OPENROWSET.
Check out the article I linked to in my first post.
Edit: Oops you posted that you were checking that out while I was posting this. Please disregrad.
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