0

We receive the following error message when trying to connect via Power BI to my database on SQL Server 2016:

“SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.”

When I run the application it's perfect. But when the user runs the application, he gets the message above.

It seems to point toward certificates, but why don't I receive the error message when run as myself?

Giacomo1968
  • 58,727
DLM_SAVA
  • 101
  • 1
  • 5

1 Answers1

0

The quick-fix when you have an untrusted certificate (self-signed?) is to add Encrypt=false to your connection-string. This is required, since recent SQL Server versions made Encrypt=true the default, which means that a trusted certificate is required.

The best and safest fix is to use Let's Encrypt to get a CA-signed certificate from a known trusted CA for free.

You will find much more information in the post
"The certificate chain was issued by an authority that is not trusted" when connecting DB in VM Role from Azure website.

harrymc
  • 498,455