use the 'Linked Server'. you can use the sp_addlinkedserver [servername]  to add the concerned server and you will be able to connect to any server on any machine