Liking netezza to SQL server RRS feed

  • Question

  • 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)

    Tuesday, November 26, 2019 8:17 PM