Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Cannot create instance of OLE DB provider DBAmp.DBAmp

Installed and setup a new instance of DBAmp on a new ETL server. Created the linked server in SQL Server 2008 R2. When I test the connection, I get "Cannot create instance of OLE DB provider DBAmp.DBAmp for linked server ". Credentials are all good and verified.

The server is fairly locked down regarding which ports are open to it, both incoming and outgoing (not under my control), so I'm thinking that might be the issue. Any list of explicit ports DBAmp needs to function properly, for both the exe and OLE DB provider?
1 person has
this problem
+1
Reply