Symptom
- Unable to connect to Salesforce.com
- When attempting to connect to Salesforce.com from Crystal Reports, it fails with the error:
"Logon failed
Details: HY000:[Simba][Saleforce] (60) Invalid Salesforce URL used for connection: https://<connection name>/service/Soap/u/23.0.
Only URLs connecting to salesforce.com or visual.force.com are allowed. [Database Vendore Code: 60 ]"
- Note: Images and data in this SAP Knowledge Base Article is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
- SAP Crystal Reports 2013
- SAP Crystal Reports 2016
- Salesforce.com
Reproducing the Issue
- In Crystal Reports, create a new report, and in the "Database Expert", select "Salesforce.com"
- In the "Salesforce.com" window, enter the Salesforce.com server to connect to, as well as the user credentials.
- When clicking "Finish" to connect, it fails with the error:
"Logon failed
Details: HY000:[Simba][Saleforce] (60) Invalid Salesforce URL used for connection: https://<connection name>/service/Soap/u/23.0.
Only URLs connecting to salesforce.com or visual.force.com are allowed. [Database Vendore Code: 60 ]"
Cause
- The Salesforce.com server url entered in the connection is invalid.
Resolution
- To connect to Salesforce.com from Crystal Reports, ensure the server url is valid:
- In Crystal Reports, create a new report, and select the connection type: Salesforce
- In the Salesforce.com window, enter a valid url under Server. One of the valid url to connect to Salesforce is: login.salesforce.com
- Then enter your user name and password to successfully connect to Salesforce.com
Keywords
sforce, salesforce, sforce.com, cr , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem
Product
SAP Crystal Reports 2013 ; SAP Crystal Reports 2016