Skip to Content

Crystal Reports 2013 TLS 1.2 connectivity issues

I have been testing out implementing TLS 1.2 and disabling prior versions which, like others have found out, can cause issues with reports being able to run. All of the proper registry keys set per this MS article:

https://support.microsoft.com/en-ca/help/3135244/tls-1-2-support-for-microsoft-sql-server

I also have SP4 installed for SQL Server 2012 and the .NET 3.5 Framework update installed for Server 2012 R2.

The reports are using an ODBC connection to connect to SQL Server 2012 but when trying to run the report, I get the following error:

[COMException (0x8004100f): Database logon failed.] CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext) +0 CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext) +644

I tried updating the report to use a newer version of the ODBC driver for SQL Server and I get this error:

[COMException (0x800002f4): Failed to open the connection. Failed to open the connection. barcode 2704_2856_{923E651E-E24B-421D-B4B7-9B26456C876E}.rpt] CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext) +0 CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext) +644

Not sure what other areas I should be checking out.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jun 24, 2019 at 08:09 PM

    Get the latest version of CR 2013, you need one that support the MS SQL Server Native 11 client.

    Then it should work.

    Use Google and search for this KBA:

    2269180Disabling TLS 1.0 may cause Crystal Reports Designer and .NET application to fail to connect to your MS SQL Server Database 2012/2014
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.