title: Login Failed for linked server
body: <p>How to create a linked server...?</p>
  
  <pre><code>1st Server name is ABC.DATABASE1
  2nd server name is EFG.DATABASE2
  </code></pre>
  
  <p>EFG database username is <code>sa</code> password is <code>sa</code></p>
  
  <p>I want to retrive the data's from 2nd server thourgh 1st server</p>
  
  <p>In the 1st server, i exectue the store procedure like this....</p>
  
  <pre><code>exec sp_linkedserver 'EFG'
  </code></pre>
  
  <p>Executed successfully,</p>
  
  <p>When i tried to retrive the data, it is showing error as "<code>login failed for user sa, Reason: Not associated with trusted sql server connection</code>"</p>
  
  <p>How to solve this problem...</p>
  
  <p>Need help</p>