topic Re: SQL refresh error just started SSL Provider in Desktop

SQL refresh error just started SSL Provider

OneWithQuestion — Fri, 21 Jan 2022 19:33:33 GMT

This error started happening yesterday for a PBI report that was working fine for months.

I'm not sure how to track this error down to correct it. It also happens on desktop as wel as deployed to the service

Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)

Re: SQL refresh error just started SSL Provider

bcdobbs — Fri, 21 Jan 2022 20:02:38 GMT

Is it a sql server you have control of? Where is it hosted (On Prem or Cloud)?

Re: SQL refresh error just started SSL Provider

OneWithQuestion — Fri, 21 Jan 2022 21:42:04 GMT

In an Azure VM.

Re: SQL refresh error just started SSL Provider

bcdobbs — Fri, 21 Jan 2022 22:28:40 GMT

I'm fairly sure the issue will be with an ssl certificate on your azure vm. Outside of my knowledge I'm afraid. I'd do some going around that. The following link might get you started:

https://social.msdn.microsoft.com/Forums/en-US/418c669e-d312-454f-ae81-e6d524cfb1ee/add-certificate-to-azure-vm-to-encrypt-ssms-connection-to-sql-server-running-on-the-vm?forum=WAVirtualMachinesforWindows

Re: SQL refresh error just started SSL Provider

Anonymous — Thu, 27 Jan 2022 06:44:21 GMT

Hi OneWithQuestion ,

This is the related document, you can view this content:

https://community.powerbi.com/t5/Power-Query/Certificate-Chain-Not-Trusted-Error-Effecting-PowerBI-Only/td-p/359157

https://community.powerbi.com/t5/Desktop/provider-SSL-provider-error-0-The-certificate-chain-was-issued/td-p/354074

https://powerbi.microsoft.com/fr-fr/blog/ssl-security-error-with-data-source/

https://dba.stackexchange.com/questions/177132/login-error-while-connecting-sql-database-through-power-bi

https://www.ibm.com/support/pages/certificate-chain-was-issued-authority-not-trusted-ssl-provider-certificate-chain-was-issued-authority-not-trusted-errors-caused-not-trusting-sql-servers-encryption-certificate

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.