Skip to Content
0
Former Member
Nov 08, 2010 at 09:29 AM

CRVS2010 Beta 2 - "Database Logon failed" Error, after Upgrade

18 Views

Hi,

Generally: we are using the Crystal Reports in combination with a DataSet, that is filled during runtime and pushed to the report, using "SetDataSource". The Project is an ASP .NET 3.5 Project, published on our server.

I upgraded my development-machine to CRVS2010 (installed both packages - the CRVS for VS 2010 and the runtime) last week and changed some fields in the Report. The DataSet was left unchanged. Everything is working well on my development-machine, but when I publish the Project to our server, I get an "Databse Logon failed" Error, when I want to create my Report. The CRVS2010 Beta 2 redist Runtime is installed on our server. Here is the code, we use:

// create new Report
var report = new Reports.repMyReport();
...
// DataSource ds was filled correctly (we checked with export to XML
report.SetDataSource(ds);
...
// Set several Parameters to Report
report.SetParameterValue("test", "test");
...
// Export Report to PDF-Format and open in Browser
report.ExportToHttpResponse(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Response, false, "reportName.pdf");
Response.End();

The error I get is:

Database logon failed.

[COMException (0x8004100f): Database logon failed.]

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

CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext) +260

[LogOnException: Database logon failed.]

CrystalDecisions.ReportAppServer.ConvertDotNetToErom.ThrowDotNetException(Exception e) +325

CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext) +315

CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportRequestContext reqContext) +650

CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToStream(ExportOptions options) +98

CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToHttpResponse(ExportOptions options, HttpResponse response, Boolean asAttachment, String attachmentName) +98

CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToHttpResponse(ExportFormatType formatType, HttpResponse response, Boolean asAttachment, String attachmentName) +124

SprintBoxWeb.BuchungDruck.Page_Load(Object sender, EventArgs e) in D:\Projects\sprnt_erp\SprintBoxWeb\BuchungDruck.aspx.cs:32

System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14

System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35

System.Web.UI.Control.OnLoad(EventArgs e) +99

System.Web.UI.Control.LoadRecursive() +50

System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627

I already tried everything, found googling the web and/or searching this forum:

e.g.: perform "verify Database" on all Reports and map the DataSet.xsd again to the Report

Is that a known issue on the Beta and we should wait for the RC, or does anyone have an idea how to fix that one?

This error is really annoying!

Many thanks for your help.

kind regards

Reinhard