SAP Knowledge Base Article - Public

1738336 - Crystal Reports fails to connect to XML datasource


The following error appears while trying to refresh Crystal Report connecting to XML datasource

"Failed to retrieve data from the database" error


followed by "Cannot determine the queries necessary to get data for this report. Details: Cannot open file Server returned HTTP response code: 401 for URL: ..."



Crystal Reports 2008

Crystal Reports 2011

secured XML servlet

Reproducing the Issue

  1. Use XML native driver to create Crystal Report connecting to a servlet that retrieves data in XML format
  2. Save the report and close Crystal Reports designer
  3. Reopen the report and refresh it 


Crystal Reports is not prompting for user's credentials and attempts to log in to the datasource using an empty password


This problem identified as product defect and escalated under ADAPT01645471


KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem


Crystal Reports 2008 V1 ; SAP Crystal Reports 2011