title: What can be the Cause of this Error "Communication link failure "?
body: <p>Respected Experts,</p>
  
  <p>I have just joined a new company.</p>
  
  <p>We have created a replicated database to store the replicated data from MS power Bi. We made a stored procedure to select data from cloud database and insert that in our server. When we are executing our stored procedure to get last 12 months data we are getting this error:</p>
  
  <p><strong>Executed as user: abcserver\useradmin. Stored Procedure  failed with error:TCP Provider: An existing connection was forcibly closed by the remote host. [SQLSTATE 42000] (Error 50000)  OLE DB provider "SQLNCLI11" for linked server "BI-Server" returned message "Communication link failure". [SQLSTATE 01000](Error 7412).  The step failed.</strong></p>
  
  <p>The main points of consideration are:</p>
  
  <ol>
  <li>Last week It was working perfectly for 12 months data. Just stopped 3 days before.</li>
  <li>Currently it is successfully working for 3 months data. But we are unable to get more then that.</li>
  <li>There is not any dramatic change in the database records(means row count)</li>
  </ol>
  
  <p>Can you please guide me what can be the cause for this error. Please help.</p>
  
  <p>I have tried increasing the packet size and connection timeout but does not work.</p>
  
  <p>Thanks</p>