DataBase logon failed, VS 2013

[former_member646330]

When running a crystal report in a web app for VS 2013, I receive the error DataBase logon failed.

[former_member646330 · Accepted solution]

This happens on the development machine and where I will deploy the app.

Database logon failed. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Runtime.InteropServices.COMException: Database logon failed.

[COMException (0x8004100f): Database logon failed.]  CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.GetLastPageNumber(RequestContext pRequestContext) +0  CrystalDecisions.ReportSource.EromReportSourceBase.GetLastPageNumber(ReportPageRequestContext reqContext) +261 [LogOnException: Database logon failed.]  CrystalDecisions.ReportAppServer.ConvertDotNetToErom.ThrowDotNetException(Exception e) +334  CrystalDecisions.ReportSource.EromReportSourceBase.HandleException(Exception exception) +119  CrystalDecisions.ReportSource.EromReportSourceBase.GetLastPageNumber(ReportPageRequestContext reqContext) +277  CrystalDecisions.CrystalReports.Engine.FormatEngine.PrintToPrinter(Int32 nCopies, Boolean collated, Int32 startPageN, Int32 endPageN) +68  CrystalDecisions.CrystalReports.Engine.ReportDocument.PrintToPrinter(Int32 nCopies, Boolean collated, Int32 startPageN, Int32 endPageN) +79  ProspectKeeperWeb.vprint.printButton_Click(Object sender, EventArgs e) in n:\print.aspx.cs:35  System.Web.UI.WebControls.Button.OnClick(EventArgs e) +118  System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +112  System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10  System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13  System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36  System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5563

[former_member183750 · Accepted solution]

What version of CR? (include service pack applied)

What database?

How are you connecting to the database?

What version client of the database is used?

Does the report work anywhere?

Subreports? If so, are they using the same db and connection type?

If you comment out all db logon code, the report should prompt for a db log on. All you need to do is enter the password. Does that work?

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow us on Twitter

[former_member646330 · Accepted solution]

I deleted the dataset, recreated the dataset and the problem mysteriously went away.