2023年1月11日 星期三

.Net Core provider: SSL Provider, error: 0 - 此憑證鏈結是由不受信任的授權單位發出的

A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - 此憑證鏈結是由不受信任的授權單位發出的。)
連線字串有問題
Server=192.168.0.1;Database=xxdb;user id=test;password=test1234;
加入TrustServerCertificate=true
Server=192.168.0.1;Database=xxdb;user id=test;password=test1234;TrustServerCertificate=true;
參考資料
[SQL Server] A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - 此憑證鏈結是由不受信任的授權單位發出的。)誤