Hi, Good Morning.
I have installed the recent "Microsoft OLE DB Driver for SQL Server" using below link.
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:
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