Khắc phục lỗi The certificate chain was issued by an authority that is not trusted

Hướng dẫn khác phục lỗi 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.) khi connect SQL Server

1. Đối với connect string các bạn thêm option sau nhé TrustServerCertificate=True

2. Đối với Microsoft SQL Server Management trước khi connect các bạn chọn Option > Connect Properties và chọn Trust server certificate


Chúc các bạn thành công.

Bình luận