3784425 - "Logon failed" with System.Xml.XmlException when opening ADO.NET (XML) reports in Crystal Reports

• When opening a report based on an ADO.NET (XML) DataSet, SAP Crystal Reports fails with the following error:

  • Logon failed.

    Details:
    System.Xml.XmlException:
    Type 'http://schemas.microsoft.com/sqlserver/2004/sqltypes:uniqueidentifier' is not declared.

• The reports may have worked previously on another environment but fail after being moved to a new server.

• SAP Crystal Reports
• Reports based on ADO.NET (XML) Dataset

1. Configure an SAP Crystal Reports report using an ADO.NET (XML) DataSet.
2. Open the report in SAP Crystal Reports.
3. Notice the Logon Failed error.

• The XSD references the Microsoft SQL Server XML schema using an external import.
• If the client machine cannot access the URL specified in the schemaLocation attribute (for example, due to firewall, proxy, or network restrictions), Crystal Reports won't be able to resolve the SQL Server data types such as sqltypes:uniqueidentifier.

• Verify that the machine running SAP Crystal Reports can access the URL referenced by the XSD import.
• If the URL is blocked by firewall, proxy, or other network restrictions, update the network configuration to allow access.

crystal, reports, Crystal Reports 2025, ADO.NET, xml, xsd, sqltypes.xsd, uniqueidentifier, System.Xml.XmlException, type, not declared, logon, failed, schemaLocation, firewall, proxy, sqltypes

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