@dandora MS team has checked and resolved the issue in an offline session.
However for similar issue please follow the below steps:
- Check and ensure that setting "Lock sessions to the IP address from which they originated" is disabled.
https://help.salesforce.com/articleView?id=000351933&language=en_US&mode=1&type=1 - Salesforce API access should be enabled. To verify access settings, go to profile settings for the current user and search for "API Enabled" checkbox. https://support.geckoboard.com/hc/en-us/articles/217148797-How-do-I-enable-API-access-in-Salesforce-#:~:text=Enable%20API%20access%20in%20Salesforce%20by%20profile,-Note&text=Click%20on%20Setup.,check%20the%20API%20Enabled%20box.
- Refer to the this document for all known issues and limitations with Sales Force connector:
https://learn.microsoft.com/en-us/connectors/salesforce/#known-issues-and-limitations - Check if the salesforce account is not a trial account : https://learn.microsoft.com/en-us/connectors/salesforce/#known-issues-and-limitations
[In this case, point 1 solved the issue]