title: Teradata Linked Server in SQL 2005
body: <p>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:</p>
  
  <p>Msg 7399, Level 16, State 1, Line 1
  The OLE DB provider "TDOLEDB.1" for linked server "TERADATA" reported an error. Access denied.</p>
  
  <p>Msg 7350, Level 16, State 2, Line 1
  Cannot get the column information from OLE DB provider "TDOLEDB.1" for linked server "TERADATA".</p>
  
  <p>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.</p>
  
  <p>--CDW</p>