The Certificate Chain Was Issued By An Authority That Is Not Trusted

[ddi98]

Hi, as the title suggests when I try to connect using SSMS I get the following error: "The Certificate Chain Was Issued By An Authority That Is Not Trusted" this problem is easily solved by disabling Encrypt connection from the "Connection Properties" section the problem arises when I have to connect a sql server management that is not SSMS where I can not choose to disable encrypt connection.

So I tried disabling force encryption by following this guide: https://www.alibabacloud.com/blog/enable-ssl-encryption-for-an-mssql-network-transport-layer_595348#:~:text=On%20the%20SQL%20Server%2C%20click,Certificate%20tab %20and%20click%20OK.

the problem is that I don't find any entry in protocols! this prevents me from both installing an ssl certificate and disabling the "force encryption" item

I hope there is a solution to my problem, in any case congratulations for the work done

[ddi98]

hello, but is there a solution to this problem? otherwise I will have to abandon windows ARM Have a good evening

[Tjiffels]

Hallo, I found a way to fix this. When trying to login from SSMS click on the "options" dropdown and untick the encryption option.