I've setup the ODBC connection, tested it, it's fine. Created the linked server as described (though it's unclear what the product name should be) and I get a security error popup:
Code: Select all
The OLE DB provider "SQLNCLI11" for linked server "Z" reported an error. Authentication failed.
Cannot initialize the data source object of OLE DB provider "SQLNCLI11" for linked server "Z".
OLE DB provider "SQLNCLI11" for linked server "Z" returned message "Invalid authorization specification". (Microsoft SQL Server, Error: 7399)
Code: Select all
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "MSDASQL" for linked server "x" reported an error. Access denied.
Msg 7301, Level 16, State 2, Line 1
Cannot obtain the required interface ("IID_IDBCreateCommand") from OLE DB provider "MSDASQL" for linked server "x".
Any thoughts?