Since last week connections to our on prem SQL servers have been failing through the data gateway. This machine is only used as a Data Gateway. When a report is published, the error returned is "The certificate chain was issued by an authority that is not trusted". I can see from wireshare traces that the client has started to request encryption and as the SQL Server is using the self generated, self signed fallback certificate, its not able to reust it. I dont know why this is happening as there have been no installs, updates or security poilicy changes, and I dont even know what could casue that, even if there was any of those. I see ion 2022 there was some updates to various SQL drivers such as OLEDB, ODBC and JDBC where the later versions of those have changed to "Default Encrypt" but I am not suing those drivers, I beleive the PowerBI connection (unless you select an OLE DB driver) will use ADO.NET and also I have tested with PowerShell, using Invoke-SqlCmd and that shows the same behavior (with Invoke-SqlCmd you can supply a -TrustServerCertificate and that works OK). So those will both use ADO.NET (I beleive) and that isnt updated outside of the .Net framework, and there has been no such updates. Why am I now seeing this?
