title: deferred prepare could not be completed, 3 SQL Servers
body: <p>I have 3 SQL Servers, and I'm getting strange behavior with OpenRowset.</p>
  
  <p>Given:</p>
  
  <ul>
  <li>Server 1 = 192.168.1.1,</li>
  <li>Server 2 = 192.168.1.2,</li>
  <li>Server 3 = 192.168.1.3,</li>
  <li>Server 4 = 192.168.1.4</li>
  </ul>
  
  <p>SQL:</p>
  
  <pre><code>SELECT a.* 
  FROM OPENROWSET('SQLOLEDB', 
                  'Data Source=192.168.1.1;Persist Security 
  Info=True;uid=sa;pwd=password',  
                  'SELECT * FROM  dfs_database.dbo.dfs_vehicledata ') AS a; 
  </code></pre>
  
  <p>Here is the strange part: if I run the above SQL statement on servers .3 and .4, everything works fine.  </p>
  
  <p>However, if I run the SQL statement on server .2, I get:</p>
  
  <blockquote>
    <p>OLE DB provider "SQLNCLI11" for linked server "(null)" returned message "Deferred prepare could not be completed.".  </p>
    
    <p>Msg 8180, Level 16, State 1, Line 7<br>
    Statement(s) could not be prepared.</p>
    
    <p>Msg 208, Level 16, State 1, Line 7<br>
    Invalid object name 'dfs_database.dbo.dfs_vehicledata'.</p>
  </blockquote>
  
  <p>So what could make one relationship not work when the others work fine? Any ideas? They are all SQL Server express, and all report having SQLNCLI11 providers.</p>