DataSource.Error: Microsoft SQL - Power BI

Question

Good day, I have a problem with Power BI, when I try to import a database it generates the following error: DataSource.Error: 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.).

 

This happens to me only with the new versions, with the November version I don't have that problem.

 

Would someone help me solve it?

Answer 1

You have three options:

1. Specify that encryption is optional. (Modern drivers defaults to required it.)
2. Select the option Trust Server Certificate.
3. Install a proper certificate from a trusted certificate provider on the SQL Server instance.

The latter is likely to be more work, and may also incur extra costs. However, you need to weigh that against the alternatives. With no encryption, anyone can eavesdrop on the communication. With the second alternative, someone can still get in the way and present itself as the SQL Server instance with a certificate. This is a so-called man-in-the-middle attack. The more sensitive your data is, the more compelling it is to use proper encryption.

For details on how to set these options with PowerBI, it may be better to use the PowerBI forum at https://learn.microsoft.com/power-bi/.

Answer 2

Hi @Gaston N Escobar,

This error occurs when you try to make an encrypted connection to SQL Server using a non-verifiable certificate.

If you intentionally use either a certificate from a non-trusted authority or a self-signed certificate to encrypt connections to SQL Server, you can use one of the following options mentioned in the article.

"The certificate received from the remote server was issued by an untrusted certificate authority" error when you connect to SQL Server

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 3

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

Add "Encrypt=False" to the connection string to surpress connection encryption by SSL, see

https://www.connectionstrings.com/all-sql-server-connection-string-keywords/