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

Linked server failing after Salesfore instance refresh


Salesforce moved our production org to a different server and the DBAmp refresh has been failing since then with the below error.

Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "DBAmp.DBAmp" for linked server "SF_BRIX_LS". The provider supports the interface, but returns a failure code when it is used.

I am able to login with the user credentials into SF and DBAmp connection shows a success status as well. But the linked server keeps failing. Please help!!!!!!
1 person has
this question