Liking netezza to SQL server

Category: sql server datamining


FrankB3456 on Tue, 26 Nov 2019 20:17:17

I am trying to link a IBM Netezza server to a Microsoft SQL server I have installed the OLE DB driver.

I am getting the following error can someone help

TITLE: Microsoft SQL Server Management Studio

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click:


An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)


The OLE DB provider "NZOLEDB" for linked server "NETEZZA16" reported an error. Access denied.
Cannot obtain the required interface ("IID_IDBSchemaRowset") from OLE DB provider "NZOLEDB" for linked server "NETEZZA16". (Microsoft SQL Server, Error: 7399)