linked server operation I am trying to insert rows from server1.table1 to server2.table2. I already create a linked server in order to query tables in both servers and it works.

However because server2.table2 has an identity column,and though I put the hint set identity_insert table2 on,
  the insert operation failed and I got the following errors in french:

L'objet "192.168.0.36.wt_delivery.dbo.table2" est introuvable, car il n'existe pas ou vous ne disposez pas des autorisations requises.


which mean that the object 192.168.0.36.wt_delivery.dbo.table2 is not found or we don't have the required permission to do the operation.

when I create the same table without the identity column the insert operation succeed!!

The query was executed from server1

Is there a specific permission that allow the operation to succeed or the problem is not at permission level?

Thank you
Microsoft documentation indicates that you can only use a 3-part naming convention for the SET IDENTITY_INSERT command. 


  SET IDENTITY_INSERT [ database_name . [ schema_name ] . ] table { ON | OFF }  


Somebody else had this same issue, and provided a solution using a temp table, and remote stored procedure to do the work.