How to fix: ERROR [HY000] [Microsoft][Salesforce] (148) INVALID_LOGIN: Invalid username, password, security token; or user locked out. ERROR [HY000] [Microsoft][Salesforce] (148) INVALID_LOGIN: Invalid username, password, security token; or user locked ou

Question

Same thing happens for 3 different orgs that I've tried. Url, username, password and token are 100% sure correct. Already tried to reset passwords and tokens few times and it doesn't help still get message:

ERROR [HY000] [Microsoft][Salesforce] (148) INVALID_LOGIN: Invalid username, password, security token; or user locked out.

ERROR [HY000] [Microsoft][Salesforce] (148) INVALID_LOGIN: Invalid username, password, security token; or user locked out.

Activity ID: 95a83977-9f4b-4ac6-b36d-93840cbc0a73.

Answer 1

Hello @Jakub Woznicki Welcome to QnA forum,

Is the Salesforce Account locked?
Did you try from Postman to connect to Salesforce? can you provide more info if you were able to get token via Postman client app?

The error message "INVALID_LOGIN: Invalid username, password, security token; or user locked out" indicates that there is an issue with the credentials that are being used to connect to Salesforce from Azure Data Factory.

Here are some steps you can take to troubleshoot this issue:

1. Check the Salesforce login credentials that are being used in Azure Data Factory. Make sure that the username, password, and security token are correct and that they have the necessary permissions to access the data.
2. Check if there are any failed login attempts. If there are failed login attempts, it may indicate that the account has been locked out due to too many failed attempts.
3. Check the Salesforce IP restrictions to make sure that the IP address of the Azure Data Factory instance is allowed to access the Salesforce account?

Check the Salesforce API access settings to make sure that the API is enabled for the Salesforce account.

1. Check the version of the Salesforce connector that you are using in Azure Data Factory. Make sure that you are using a version of the connector that is compatible with the version of Salesforce that you are using.

I hope this helps! Let me know if you have any further questions.