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

[Former Member]

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

[former_member11696 · Accepted solution]

See this thread for more info:

[former_member183750]

1) Make sure you do not have any other version of CR on this box (see the note in the sticky post at the top of this forum)

2) See [this|] thread.

3) If (1) above is true and (2) above does not help, see [this|https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/13270] [original link is broken] [original link is broken] [original link is broken]; blog on troubleshooting issues with datasets.

Ludek

Follow us on Twitter http://twitter.com/SAPCRNetSup

Got Enhancement ideas? Try the [SAP Idea Place|https://ideas.sap.com/community/products_and_solutions/crystalreports]

[Former Member]

Dear Ludek,

Many thanks for your quick reply. Currently, I have to finish some other things. I will try your ideas next week and give you some feedback then, to keep you informed.

best regards,

Reinhard