title: linked server OLE DB provider "SQLNCLI11" for linked server
body: <p>Hello I have 2 different SQL Server databases.</p>
  
  <p>They are connected to each other via a linked server.   The linked server is working fine.</p>
  
  <p>When i try:</p>
  
  <pre><code>SELECT 
      * 
  FROM 
      OPENQUERY
          ([192.168.1.170], 
          'SELECT MalCRM.dbo.ContractedNumber(1)')
  </code></pre>
  
  <p>I get the below error. How I can fix it?</p>
  
  <blockquote>
    <p>OLE DB provider "SQLNCLI11" for linked server "192.168.1.170" returned message "Deferred prepare could not be completed.".
    Msg 229, Level 14, State 5, Line 1
    The EXECUTE permission was denied on the object 'ContractedNumber', database 'MalCrm', schema 'dbo'.</p>
  </blockquote>