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.
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
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?
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
Thank you for your reply, we have updated the cumulative update for SQL server , but still its not working .
we are fetching data from service now with soap.troux user , and using remote user security option in linked server
is this a sql user you are using?
yes we are using the same
Is this issue resolved? I have same issue with SQL Server linked server for ServiceNow.