Hi Oladayo, thanks for sending the details.
So this is basically an issue with the version of SQL or OLEDB provider installed on the server you have pushed out to. You would basically have to install/update to a newer version of Microsoft OLE DB. Please see the link below to download:
Can you also please send me the following information:
Windows Server OS Version?
MS SQL Server version?
Are all latest Windows updates installed on the server?
Please see the following link on how to resolve it:
This is helpful as well:
If you are not able to resolve this or can't make changes on the server, we can also try and resolve this in code as a last resort, by switching all instances of OleDB provider to Sql. You would have to change OleDbConnection, OleDbCommand, OleDbDataAdapter to SqlConnection, SqlCommand, SqlDataAdapter in ReportController. It might not give you the TLS related error or it might give you the same error again, I'm not sure as it's a .NET framework level issue.
However, I would strongly encourage to resolve by updating the server first as it would enhance security on your server as well. Another thing is if you decide to host dotnetreport on prem, and we send you the service to setup on IIS, it might have the same problem.
Let me know if you are able to resolve this or not.
dotnet Report Team