C
C#2y ago
najlaaae

❔ The certificate chain was issued by an authority that is not trusted.

Whenever I run the Update-Database command, I encounter an error related to the SSL certificate chain. The error message states that the certificate chain was issued by an authority that is not trusted. This error occurs during the login process to the SQL Server. While creating the project I didn't configure it for HTTPS. So it's possible that the SQL Server instance is attempting to establish an SSL/TLS-encrypted connection (HTTPS) even though it's not configured to do so. Troubleshooting Steps Performed: I've already checked Trust Server Connection while connecting in SQL Management Studio. In my default connection string, I've set Trusted_Connection to true, MultipleActiveResultSets to true, TrustServerCertificate to true. I've been playing with parameters by changing their values several times and trying the command again but in vain. Also I've tried to connect to SQL Management Studio using SQL Server Authentication and enabling the user sa, and adding this connection string "MyConn": "Server=DESKTOP-Q8E2E3O\\SQLEXPRESS;Database=bank-app;User ID=sa;Password=123" but still the same issue with the certificate. If you have any idea what the solution could be please let me know, I've been struggling with this for like 6 hours today.
2 Replies
Suiram1
Suiram12y ago
Thats normal when you use local databases. You only must add to the connection string Trusted_Connection=True; That has the reason that on your local pc no SSL certificate is installed.
Accord
Accord2y ago
Looks like nothing has happened here. I will mark this as stale and this post will be archived until there is new activity.
Want results from more Discord servers?
Add your server