Skip to Content
0
Jan 20, 2023 at 09:32 AM

Crystal Report Designer Connection Error for Microsoft OLEDB Driver 19 for SQL server

559 Views Last edit Jan 20, 2023 at 09:39 AM 2 rev

Hi, Good Morning.

I have installed the recent "Microsoft OLE DB Driver for SQL Server" using below link.

https://learn.microsoft.com/en-us/sql/connect/oledb/oledb-driver-for-sql-server?view=sql-server-ver16

And i could connect to the sql server and preview the crystal report programmatically in sample application by specifying the provider details as MSOLEDBSQL in the connection string.

Provider=MSOLEDBSQL;

And also

set the "Trust Server Certificate=true";

As per the below link suggestion fix:

https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/certificate-chain-not-trusted?tabs=ole-db-driver-19

Before fix(without "Trust Server Certificate=true" in connection string) i was facing connection error.

"SSL Provider: The certificate chain was issued by an authority that is not trusted."

Problem what i am facing now is:

In the Crystal Report Designer, when i try to preview the same above report by selecting provider in database expert as Microsoft OLE DB Driver(Microsoft OLEDB Driver 19 for SQL server"), i am getting the below error:

"

Logon Failed.

Details:ADO Error Code:0x80004005

Source:Microsoft OLE DB Driver 19 for SQL Server

Description: SSL Provider: The certificate chain was issued by an authority that is not trusted.

SQL State:08001

Native Error:-2146893019[Database Vendor Code: -21468"

How do i fix this in crystal report designer as i fixed in sample application by adding "Trust Server Certificate=true" in connection string?

Thanks,

Samson