Linked servers do not create logins\users, they map between them. What you are trying to do seems to be map a SQL Server login on the remote server to your windows login locally. This is fine but your Windows login must already have rights on the local server, and the SQL login must already be created and have rights on the remote server.