linked server OLE DB provider "SQLNCLI11" for linked server
<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>