ASP.NET 4 :: An exception of type 'CrystalDecisions.CrystalReports.Engine.LogOnException' occurred and was caught.

Question

User-1301396245 posted

Hi,

We've just deployed crystal reports on our qa environment and whenever we try to run the reports it gives following error.

Timestamp: 4/16/2013 6:09:48 PM
Message: HandlingInstanceID: 85c297c5-4076-4b29-b8b2-0e289c5ca983
An exception of type 'CrystalDecisions.CrystalReports.Engine.LogOnException' occurred and was caught.
-----------------------------------------------------------------------------------------------------
04/16/2013 18:09:48
Type : CrystalDecisions.CrystalReports.Engine.LogOnException, CrystalDecisions.Shared, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304
Message : Database logon failed.
Source : CrystalDecisions.ReportAppServer.DataSetConversion
Help link :
ErrorID : LogOnFailed
Data : System.Collections.ListDictionaryInternal
TargetSite : Boolean ThrowDotNetException(System.Exception)
HResult : -2147215360
Stack Trace : at CrystalDecisions.ReportAppServer.ConvertDotNetToErom.ThrowDotNetException(Exception e)
at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)
at CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportRequestContext reqContext)
at CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToStream(ExportOptions options)
at CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToStream(ExportFormatType formatType)

We tried everything but couldn't fix the issue. Can you please help us?

Thanks,

Sachin Pawar

Answer 1

User-578610739 posted

hi

I am not sure whether it help or no, but found following link:

Read Carefully. check this dll ( crystaldecisions.reportappserver.datasetconversion.dll  and CrystalReportsXX_NET_EmbeddedInstall.msi)
http://ftp1.businessobjects.com/outgoing/CMS/crXIwin_en_sp3.pdf (directly search or go  ADAPT00338564 Patch ID: 36855983)

Description:

When datasets are set to a report with two or more tables, the following error message appears: "exception of type

'CrystalDecisions.CrystalReports.Engine.LogOnException' occurred in crystaldecisions.reportappserver.datasetconversion.dll." The

error message is thrown by the merge modules in CrystalReportsXX_NET_EmbeddedInstall.msi.

New Behavior:

This problem is resolved

0r.

http://bytes.com/topic/c-sharp/answers/253631-crystaldecisions-crystalreports-engine-loadsavereportexception-when-opensubreport-called

I think connection string, while assign, is it able to connect db?

Answer 2

User-578610739 posted

Hi,

http://scn.sap.com/thread/1886030

http://forums.asp.net/t/331293.aspx/1

https://groups.google.com/forum/?fromgroups=#!topic/dotnetdevelopment/wvl9RIC9-7w

I think data assign issue, more time or less you assign the same thing. please check step by step and compare with an example.

Answer 3

User-1301396245 posted

Thanks all! The issues was there because SQL Server 2008 Native Client was not installed on the machine. We had installed only required software the production machine. It did not have SQL Management Studio installed on the server and so the native client.

After reading various blogs, I could figure out it could be sql native client issue.

Thanks all again. I appreciate your time.