Liking netezza to SQL server

Category: sql server datamining

Question

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:

------------------------------
ADDITIONAL INFORMATION:

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)