I am trying to connect to Teradata using a Linked Server in SQL Server 2005. When I try to use SQL Server to connect using OPENQUERY, I get the following errors:
Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "TDOLEDB.1" for linked server "TERADATA" reported an error. Access denied.
Msg 7350, Level 16, State 2, Line 1 Cannot get the column information from OLE DB provider "TDOLEDB.1" for linked server "TERADATA".
When I "Test Connection" the test succeeds, but when I try to view the Catalog default Tables in SQL Server Management Studio, I get the same error. I have Visual Studio installed on the computer running SQL server (it is a dev box), and I can connect using the OLE DB driver and I can run my query, and navigate to the Catalogs default Tables. Is there some trick to getting a linked server to work with Teradata? Any suggestions are greatly appreciated.
--CDW