New to Telerik Reporting? Download free 30-day trial

The certificate chain was issued by an authority that is not trusted

Environment

Product Progress® Telerik® Reporting
Component SqlDataSource

Description

When attempting to use the Query Designer in the Visual Studio Report Designer or in the other Report Designers when explicitly having selected the Microsoft.Data.SqlClient data provider, the connection fails during the login process.

Error Message

SqlException (0x80131904): 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.)]

Cause

In versions 4.0.0 or newer of the Microsoft.Data.SqlClient data provider, the default value of the Encrypt connection setting has been changed from false to true as an attempt to improve the security with the default settings.

Solution

Short-term Solution

UseTrustServerCertificate=True in the connection string. The SQL Server will create a self-signed certificate if you don't install one for it to use, but it won't be trusted by the caller since it's not CA-signed, unless you tell the connection string to trust any server cert by default.

Long-term Solution

Install a CA-signed certificate from a trusted CA such as Let's Encrypt`.

See Also

In this article