Linked Server Access Error from SQL Agent Job

SQL Server Administration
1

Hi All,

I created One Linked Server to access another SQL Server. I am able to execute that step in query window but for few steps getting a below error. Please guide me on this.

Message:
Executed as user.NT SERVICE\SQLSERVERAGENT.Cannot fetch a row from OLEDB provider "MSDASQL"for linked server "servicenow". [SQLSTATE 42000] (Error 7330) OLEDB provider"MSDASQL"for linked serverreturned message "[SN][ODBC servicenow driver][OPENACCESS SDK SQL ENGINE].Error un-initializing the cache for disk storage[10103]

2

do you have a dedicated domain user service account for sql services running on both sql servers?
what type of security are you using to link to linked server?

3

The issue was first fixed in the following cumulative update of SQL Server:
Cumulative Update 1 for SQL Server 2016

Recommendation: Install the latest cumulative update for SQL Server

4

Thank you for your reply, we have updated the cumulative update for SQL server , but still its not working .

5

we are fetching data from service now with soap.troux user , and using remote user security option in linked server

6

is this a sql user you are using?

7

yes we are using the same

8

Is this issue resolved? I have same issue with SQL Server linked server for ServiceNow.