title: Login to another server from Current server using Server Authentication
body: <p>I googled a lot but did'nt find clear solution<br>
  I am trying to insert data from a   </p>
  
  <pre><code>table1 of a database1 from server1  
  </code></pre>
  
  <p>to   </p>
  
  <pre><code>table2 of database2 from server2  
  </code></pre>
  
  <p>where i am unable to login to server2 because of sqlserver authentication  </p>
  
  <ol>
  <li>So my question is how to connect to server2 using server authentication from server1 ??  </li>
  <li>Also give me simple solution to insert data from one server to another ??</li>
  </ol>