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

security token; or user locked out.". error during accessing tables

hi

When i access select Query i get result but most of the time i get this error again and again.

OLE DB provider "DBAmp.DBAmp" for linked server "salesforce" returned message "Error 1 : INVALID_LOGIN: Invalid username, password, security token; or user locked out.".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "DBAmp.DBAmp" for linked server "salesforce".

and this when i click on object explorer.

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

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

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

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

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

Cannot initialize the data source object of OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE". (Microsoft SQL Server, Error: 7303)

Kindly help to resolve this Issue ..
Thanks With Regards
1 person has
this question
+1
Reply
  • INVALID_LOGIN: Invalid username, password, security token; or user locked out.

    This message is from the salesforce server. Salesforce is rejecting the credentials you entered on the security page of the linked server. Please make sure you have the proper credentials by attempting to login to salesforce directly.

    If you are trying to connect to a sandbox org instead of your production org, make sure you have entered the following value for the LOCATION parameter of the linked server:

    https://test.salesforce.com

    This points DBAmp to the sandbox instead of the production org.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned