Crystal Report is giving System.Runtime.InteropServices.COMException: Database logon

[SankarN]

We are using Plesk 9.5 in our dedicated server and Crystal Report for Reporting. All Reports are working but in the morning we are getting the following error when any reports is taken

Server Error in '/' Application.
--------------------------------------------------------------------------------


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.

Source Error:


An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:



[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) +649
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) +123
ScaffoldTrack.Reports.ScaffoldReportMain.BindReport(DataTable _datatableReport, String _reportname) in e:\ScaffoldTrack\ScaffoldTrack\Reports\ScaffoldReportMain.aspx.cs:421
ScaffoldTrack.Reports.ScaffoldReportMain.Page_Load(Object sender, EventArgs e) in e:\ScaffoldTrack\ScaffoldTrack\Reports\ScaffoldReportMain.aspx.cs:238
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


If we stop and start Plesk report will show correctly and up to next day morning there is no issue. Can any one suggest a solution?