I have two linked servers setup on my SQL server 2008 install. For some reason, these linked servers work just fine, until I restart the SQL service, or restart the SQL server itself. Before a restart of either, I can test the connection and it is successful. After a restart of either, I test the connection and it fails with the "Cannot create instance of OLE DB provider "TDOLEDB.1" for linked server "teradata_a". (Microsoft SQL Server, Error: 7302)". The teradata client is 13.10.
The weird thing is by the next morning it seems to clear itself up on its own, almost like there is some link that gets reset between the teradata server and my SQL server. However, in the meantime I can connect successfully via the Teradata SQL Assistant on the server.
Anybody else run across this and/or know of a fix?