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
phaseshift•2y ago
Where was the certificate signed?
Metalkon
Metalkon•2y 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
Accord•2y 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
More Posts
✅ dotnet new react - with mvc?I want to learn and use React. How do I create an app that uses both react and mvc using cli? I can How do I call the constructor of a parent class?If I have something like ```cs abstract class parent { public parent(string mom, string dad) {...}❔ Hi i need help with error SeverityCodeDescriptionProjectFileLineSuppression StateErrorCS1501Here the codeMake a new type that essentially acts like anotherIn my project, I've found that Im making a lot of structs/classes that are essentially containers f❔ Error with NaudioI only can play the audio once and then no sound is played✅ this extractor writes the project name + the file name how do I make it just say the file nameThis extractor ~~which I got from stackoverflow because I dont know how to code in c# that much~~ wh✅ RestSharp not using given ProxyHey all! I know this is quite off topic from regular C# as this post is bound to a NuGet Package but❔ Access Resources FileHey, sorry to bother - quick question. I created a EmailResources.resx file inside a "Resources" fol