CrystalDecisions.CrystalReports.Engine.LogOnException: Database logon faile

2114 Views

I am using a typed dataset as the data source of a report in an ASP.NET 1.1 application. The appliation works well for couple of years for 2 customers. After the same system was installed for a new customer, it brokes from time to time. What I don't understand is that why CR gives a "Database logon faile" error while it does not connect to DB directly to retrieve the data. And why it works sometime, but failed some othertime without any change to the application or environment (per customer). since this is non-reproducible in our dev envrionment, I am wondering if any one seen similar problem. You help is greatly appreciated.

We use CR XI release 2, ASP.NET 1.1. customer has windows 2003, SQL 2000 (maybe with failover cluster). thanks.

CrystalDecisions.CrystalReports.Engine.LogOnException: Database logon failed. ---> System.Runtime.InteropServices.COMException (0x8004100F): Database logon failed.

at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext)

at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)

--- End of inner exception stack trace ---

at CrystalDecisions.ReportAppServer.ConvertDotNetToErom.ThrowDotNetException(Exception e)

at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)

at CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportRequestContext reqContext)

at CrystalDecisions.CrystalReports.Engine.ReportDocument. (ExportOptions =)

at CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToStream(ExportFormatType formatType)