Help get this topic noticed by sharing it on Twitter, Facebook, or email.
I’m confused

The linked server has been created but failed a connection test.

Setting up Linked Server. Can connect to Salesforce via the config tool Test Connection , but same security credentials don't work in Linked Server. Followed prerequisities and setup guide 3.4.9.

Error message text as below:

TITLE: Microsoft SQL Server Management Studio
------------------------------

The linked server has been created but failed a connection test. Do you want to keep the linked server?

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

The OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE" reported an error. The provider did not give any information about the error.
Cannot connect using OLE DB provider "DBAmp.DBAmp" to linked server "SALESFORCE". Verify the connection parameters or login credentials associated with this linked server. (Microsoft SQL Server, Error: 7399)

For help, click: http://go.microsoft.com/fwlink?ProdNa...

------------------------------
BUTTONS:

&Yes
&No
------------------------------
2 people have
this problem
+1
Reply