IBM Support

Access Denied with SQL Server Linked Server and the IBM OLEDB Provider

Question & Answer


Question

A query may fail with one of the following errors, when using Microsoft® SQL Server Linked Server with the IBM OLE DB provider: - The OLE DB provider "IBMDADB2" for linked server "" reported an error. Access denied. Cannot obtain the required interface ("IID_IDBSchemaRowset") from OLE DB provider "IBMDBDB2" for linked server "". (microsoft sql server, error: 7399) - Cannot obtain Schema Rowset DBSCHEMA_TABLES for OLE Provider IBMDADB2.

Cause

Microsoft® SQL Server Linked Server may not have the permission needed to use the interface from the OLE DB provider.

Answer

Enabling the "Allow InProcess" property in SQL Server Linked Server for the IBM OLE DB provider is one potential way of resolving this problem, as SQL Server would be running in the same process space as the OLE DB Provider, which may allow it to have the access privileges it requires to use the required interface.


Note: Microsoft® has an article that describes how to resolve this issue without enabling the "Allow InProcess" property. The article can be found here. For any questions or concerns about this article please contact Microsoft® support.

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Programming Interface - Other","Platform":[{"code":"PF033","label":"Windows"}],"Version":"9.7;9.5;9.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21293491

Page Feedback