ok sorry i am alittle confused am i putting in the remote server or the local server name for the LInk server:

also am i putting in the ip or server name

and am i just selecting to connect by sql and not another datasource

also when i try either local or remote server name i get

the test connection to the linked server failed

an exception occured while executing a transact - sql statement or batch