AnsweredAssumed Answered

Security error when using Linked Server to write data back to DA server using from MSSQL and or SSIS package

Question asked by LaineTedder on Jun 15, 2020
Latest reply on Jun 16, 2020 by kduffy

I can successfully write to the tag using Student01 account from SQL Commander when using PI OLEDB Provider connection.

 

However, when I try to do similar from MSSQL  using a linked server and using current user security context I receive the below error

Query Example

SELECT * FROM OPENQUERY([PIOLEDB], 'INSERT piarchive..picomp2 (tag, time, value)
VALUES (''SSISPackageTracker'', ''*'', ''test'')')

 

Error Returned

Msg 7357, Level 16, State 2, Line 9
Cannot process the object "INSERT piarchive..picomp2 (tag, time, value)
VALUES ('SSISPackageTracker', '*', 'test')". The OLE DB provider "PIOLEDB" for linked server "PIOLEDB" indicates that either the object has no columns or the current user does not have permissions on that object.

Outcomes