i see;
can't you go to the remote server, find the role that your user mydomainname\username is in, and then jsut add a SQL login to the same role?
then that logon would have the same permissions, and you can use the newly created sql logon for the linked server.
Lowell
--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!