C
C#2y ago
Metalkon

❔ Having MSSQL Cert Issues In a ASP.NET Project

Anyone have any idea on how I can solve this issue? It's only a problem with my new .net 6 project even though i'm not having this issue on my .net 5 project which is almost identical. I'm trying to migrate (update-database command) my mssql database with entity framework on a new asp.net core 6 mvc project on visual studio but i've been stumped on this error all day without finding a solution.
Error Number:-2146893019,State:0,Class:20
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.)
Error Number:-2146893019,State:0,Class:20
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.)
I tried doing the instructions on this troubleshooting page but nothing happened, chatgpt isn't saying anything useful, and the google search results i've checked haven't helped much either. https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/error-message-when-you-connect
Error message when you connect to SQL Server - SQL Server
This article provides resolutions for the problem that occurs when you connect to SQL Server using SSL.
3 Replies
phaseshift
phaseshift2y ago
Where was the certificate signed?
Metalkon
MetalkonOP2y ago
i know nothing about certificates, my previous project didn't need anything done but now everything is red alarms over certs (cannot even connect to the db that my other project uses, but the other project still works fine with migrations)
Accord
Accord2y ago
Was this issue resolved? If so, run /close - otherwise 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