Skip to main content

Crystal Reports fails to connect

  • October 5, 2020
  • 3 replies
  • 3418 views
Crystal Reports fails to connect
Jasper
Superhero

As of Windows Server 2019, Microsoft disabled the encryption protocols TLS 1.0 and 1.1 by default, and requires all connections to, for example, SQL Server instances on Windows Server 2019 to use TLS 1.2. This can cause problems with Crystal Reports documents that use the default SQL Server drivers included with Crystal Reports, instead of the Microsoft OLE DB Driver.

To resolve this, you need to replace the drivers used by each report with the latest Microsoft OLE DB Driver for SQL Server, which you can download here. To update the driver in the report file:

  1. Open the Set Datasource Location dialog from the Database menu in the Crystal Reports designer.
  2. Select the connection to replace and click Make New Connection to create a connection using the Microsoft OLE DB Driver for SQL Server or select an existing MSOLEDBSQL connection. Do not use the Microsoft OLE DB Provider for SQL Server (SQLOLEDB).
  3. Select Update to replace the connection.

Repeat this for all Crystal Reports files.

 

An alternative, more future-proof solution is to migrate from Crystal Reports to DevExpress reporting, which does not require any reporting- or database-drivers to be installed. The DevExpress report designer is part of the Thinkwise Platform and can be downloaded from TCP.

Did this topic help you find an answer to your question?
This topic has been closed for replies.

3 replies

Guido Speelziek
Apprentice

Hi Jasper,

Thanks for the information. Can you tell me how I can find out which connection our reports use at this moment?


Jasper
Superhero
  • Author
  • 678 replies
  • October 6, 2020

Sure. In the Set Datasource Location dialog, open the Properties node and check the Provider. It should say ‘MSOLEDBSQL’.

 


Additional; As of Windows Server 2022 gives the possibility of encryption Optional/Mandatory/Strict and using the latest ODBC driver 19 for SQL Server, I found it's necessery to change the standard value of the string parameter 'Use Encryption for Data' from ‘Mandatory’ to ‘Optional’.

 

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings