SQL refresh error just started SSL Provider

[OneWithQuestion]

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.)

[v-yangliu-msft]

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-O...

https://community.powerbi.com/t5/Desktop/provider-SSL-provider-error-0-The-certificate-chain-was-iss...

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-pow...

https://www.ibm.com/support/pages/certificate-chain-was-issued-authority-not-trusted-ssl-provider-ce...

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.

[bcdobbs]

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

[OneWithQuestion]

In an Azure VM.

[bcdobbs]

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-...