title: The OLE DB provider "SQLNCLI11" for linked server could not INSERT
body: <p>I have currently setup a linked server.<br />
  We have two SQL servers: server A, server B<br />
  On server A i have create a linked server to server B</p>
  <p>Now on server A i must do a insert on server B DB.<br />
  My select works fine.<br />
  Also i have given full access to the user.<br />
  Am getting the following error below:</p>
  <blockquote>
  <p>OLE DB provider &quot;SQLNCLI11&quot; for linked server &quot;serverB&quot; returned message &quot;Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.&quot;.</p>
  <p>Msg 7344, Level 16, State 1, Line 1
  The OLE DB provider &quot;SQLNCLI11&quot; for linked server &quot;serverb&quot; could not INSERT INTO table &quot;[serverb].[Data].[dbo].[test]&quot; because of column &quot;test_ID&quot;. The user did not have permission to write to the column</p>
  </blockquote>