Skip to Content
avatar image
Former Member

Database logon failed when exporting Crystal Report to PDF

I have converted a ASP.NET 1.0 app to 4.0. It is a simple app with only 3 pages and 4 reports. For the most part the conversion went well and on both my development machine and the production machine I can run it, navigate between the pages, retrieve and update data from a SQL Server 2008 R2 database. On the development machine I can also create Crystal Reports which are then exported to PDF. On the production machine however when I try to do this I get this message:

Server Error in '/EslCalls' Application.

Database logon failed.

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

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) +362  [LogOnException: Database logon failed.] CrystalDecisions.ReportAppServer.ConvertDotNetToErom.ThrowDotNetException(Exception e) +909 CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext) +471 CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportRequestContext reqContext) +772 CrystalDecisions.CrystalReports.Engine.FormatEngine.Export(ExportRequestContext reqContext) +185 CrystalDecisions.CrystalReports.Engine.FormatEngine.Export() +115 CrystalDecisions.CrystalReports.Engine.ReportDocument.Export() +80 EslCalls.Reports.MakePDFfile(ReportDocument crpt, String ReportName) in C:\WebApps\EslCalls\Reports.aspx.vb:158 EslCalls.Reports.btnSubmit_Click(Object sender, EventArgs e) in C:\WebApps\EslCalls\Reports.aspx.vb:97 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +155 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3804 

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET

On my development machine:

Windows 7


Visual Studio 2010

Crystal Reports for Visual Studio 2010

The reports had been developed in Crystal XI but they were imported in to VS 2010 converted and saved

The app runs under a application pool I created that uses a network Windows account that has all the necessary permission on the SQL Server objects.

In the web.config file identity impersonate is set to true.

On the production machine:

Windows Server 2012 R2


SAP Crystal Reports runtime engine for. NET Framework (64-bit)

The app runs under a application pool I created that uses the same Windows account as on my development machine

In the web.config file identity impersonate is set to true.

IIS and application are on one server and SQL Server is on another. The server that IIS is on is named Intranet02 and the Intranet02$ account has all the necessary permissions on the database objects.

The pertinent code:

Dim crpt As New ReportDocument()

crpt = New rptCategory()

ReportName = "Category"

MakeCrParameter(txtStartDate.Text, "@StartDate", crpt)

MakeCrParameter(txtEndDate.Text, "@EndDate", crpt)

FileName = MakePDFfile(crpt, ReportName)

Private Function MakePDFfile(ByVal crpt As ReportDocument, ByVal ReportName As String) As String

Dim TodayFile As String = Month(Now) & Day(Now) & Year(Now)

Dim FileName As String = ReportName & " " & Now.Month & "-" & Now.Day & "-" & Now.Year & "-" & Now.Second & ".pdf"

Dim dfdo As New CrystalDecisions.Shared.DiskFileDestinationOptions()

dfdo.DiskFileName = "C:\WebApps\EslCalls\Reports\" & FileName

With crpt

ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile

.ExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat

.ExportOptions.DestinationOptions = dfdo




End With



MakePDFfile = FileName

'Open a new window linked to the PDF file containing the report. The window is resizable.

Dim Script As String = "<Script language='javascript'>'/EslCalls/Reports/" + FileName + "','Reports','width=800,height=500,resizable=1')</script>"

Page.ClientScript.RegisterStartupScript(Me.GetType(), "Session Timed Out", Script, False)

'Clear the form after the report has been created

Clear() End Function

The error occurs at the line


Any suggestions would be greatly appreciated.

I have a report that doesn't connect to a database and it opens on the production machine. It seems like it must be a permissions issue but I don't know what it would be as the app should be running under the same account on both my development and my production machine and the reports open on my development machine.

I was thinking perhaps on the server the app was running under a different identity then I expected so I put Dim username As String = System.Security.Principal.WindowsIdentity.GetCurrent().Name Response.Write("User = " & username) right before the code that generates the report. On both the production and development machines it shows the correct user account.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 17, 2014 at 09:05 PM

    Hi Les

    Couple of things to check off:

    If the connection is via ODBC, make sure you are using a 64 bit ODBC datasource.

    This being MS SQL the following client installs are important:

    MS SQL 2005 - OLE DB Provider
    MS SQL 2008 - SQL Native 10
    MS SQL 2012 - SQL Native 11
    MS SQL 2013 - SQL Native 11

    For ODBC then use:

    MS SQL 2005 - SQL Native
    MS SQL 2008 - SQL Native 10
    MS SQL 2012 - SQL Native 11
    MS SQL 2013 - SQL Native 11

    Other than that, in your code I do not see any APIs for establishing a database connection(?).

    - Ludek

    Senior Support Engineer AGS Product Support, Global Support Center Canada

    Follow us on Twitter

    Add comment
    10|10000 characters needed characters exceeded