© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
C#C
C#•3y ago•
3 replies
na_tenshi

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

Whenever I run the
Update-Database
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
Trusted_Connection
to true,
MultipleActiveResultSets
MultipleActiveResultSets
to true,
TrustServerCertificate
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"
"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.
Screenshot_880.png
C# banner
C#Join
We are a programming server aimed at coders discussing everything related to C# (CSharp) and .NET.
61,871Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

❔ Microsoft SQL Server Management Studio ("authority that is not trusted")
C#CC# / help
3y ago
❔ The remote certificate is invalid because of error in the certificate chain: partial chain
C#CC# / help
3y ago
❔ Invalid remote certificate, error in certificate chain: Partial chain
C#CC# / help
3y ago
Kestrel not returning full certificate chain .NET 6
C#CC# / help
3y ago