Answered by:
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
Tuesday, April 16, 2013 2:31 PM
Answers
-
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.
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Friday, April 19, 2013 4:05 PM
All replies
-
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.
I think connection string, while assign, is it able to connect db?
Thursday, April 18, 2013 9:01 AM -
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.
Thursday, April 18, 2013 9:06 AM -
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.
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Friday, April 19, 2013 4:05 PM