Hi Lowel,
Thanks for your reply.
I have tried the first option by giving myself (myaccount) as a proxy, also i have ensure the remote file have been given access to my account.
But still i have not able to success.
It would be nice, if you have any steps i need to follow in setting up the linked server properties. (Where i need to setup my account to access the remote file.) So that i will try that option.
Your help is appreciated.
Regards, Ravi