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

Error when setting up Linked Server and testing connection

I get the SQL error below when trying to test my connection.

"The linked server has been updated but failed a connection test. Do you want to edit the linked server properties?
Additional Information:
An exception occured while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Connection Info)
Cannot initialize the data source object of OLE DB provider "DBAmp.DMAmp" for linked server "SALESFORCE".
OLE DB Provider "DBAmp.DMAmp" for linked server "SALESFORCE" returned message "Error 1: Invalid_Login: Invalid username, password, security token; or user locked out.".(Microsoft SQL Server, Error: 7303)

I have verified my username and password can log in to salesforce.com and I have also reset my security token which I have added to the end of the password for the credentials in sql.

Any help is appreciated.
1 person has
this problem
+1
Reply