Breaking News: Grepper is joining You.com. Read the official announcement!

microsoft.data.sqlclient.sqlexception: '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 truste

Code+Composer answered on October 16, 2024 Popularity 3/10 Helpfulness 1/10

answer microsoft.data.sqlclient.sqlexception: '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 truste

related powershell array list

microsoft.data.sqlclient.sqlexception: '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 truste

Comment

This error occurs because the SQL Server is using a certificate that isn't trusted by the machine.

1. Trust Server Certificate
Modify the connection string to include TrustServerCertificate=True. This setting will ignore SSL validation and allow the connection:
string connectionString = "Server=your_server;Database=your_database;User Id=your_user;Password=your_password;TrustServerCertificate=True;";

2. Update SQL Server Certificate
3. Install Certificate Manually
4. Update SQL Client Library
5. Check SSL/TLS Protocol Version

Popularity 3/10 Helpfulness 1/10 Language csharp

Source: Grepper

Tags: authority c# certificate chain connection ssl was

Link to this answer
Share Copy Link