The problem is that I don't have a mydomainname\username login on the remote sever. I must connect to that server with a SQL login. It's not the way I would do it but that part is out of my control. I was trying to map my domaim\user to a sql login but that doesn't work. It only maps to a user and tries to use your account to connect to the remote server, which fails in this case.