Base solution for your next web application
Open Closed

Connection to SQL denied #11508


User avatar
0
AceNetZero21 created

I downloaded ASP.NET CORE MVC & jQuery,.NET 7.0, v12.0.1. I couldn't create the data migration because of this error: **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.) **

The connection string contains the recommended flags: Trusted_Connection=True; TrustServerCertificate=True; Please help


1 Answer(s)
  • User Avatar
    0
    edarib created

    Try adding Encrypt=False to the connection string instead of TrustServerCertificate=True

    That's one of the breaking changes in .NET 7: https://learn.microsoft.com/en-us/ef/core/what-is-new/ef-core-7.0/breaking-changes