How to fix this error (provider: SSL Provider...)

BenTam 1,761

Dear All,

How to fix this error:

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

Code

BenTam 1,761 Reputation points

2023-10-17T09:52:10.1533333+00:00

Hi @Olaf Helper

After adding encrypt = false, the error goes away.

By the way, is there a way to remove a duplicated question?
Jiale Xue - MSFT 49,831 Reputation points Microsoft External Staff

2023-10-18T02:46:11.7233333+00:00

Hi @BenTam-3003 , Welcome to Microsoft Q&A,

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Your duplicate question, I've marked it as duplicate.

Accepted answer

Olaf Helper 46,551 Reputation points

2023-10-17T06:07:36.0733333+00:00

Current data provider uses by default an encryted connection, which only work if you have setup a certificate for SQL Server connections.

Add "Encrypt=False;" to your connection string.
Please sign in to rate this answer.
BenTam 1,761 Reputation points

2023-10-18T03:20:15.6166667+00:00

Hi @Olaf Helper

It works. May I know how to delete a duplicated question?
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

0 additional answers

Your answer